Custom SQL UDF DateTime Conversion
$25-30 USD
Pagado a la entrega
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
Nº del proyecto: #3335782