Custom SQL UDF DateTime Conversion

Writing a custom UDF in TSQL for SQL Server 2000 that converts the sample numbers below into a properly formated SQL Server DATETIME datatype (i.e. 6/24/2004 9:24:00 AM)

The field being converted with this function is in the following sample format

3166035071

3166035226

3166037014

These 3 samples represent the number of SECONDS since

Jan 01 1904 Midnight -

The original data is legacy data created by an old testing software application.

That's all there is.

## Deliverables

I just need the SQL text file that I can copy and paste into Query Analyzer that creates the UDF - shouldn't be more than a dozen lines of code at most...

## Platform

WIndows SQL Server 2000

Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #3335782

About the project