Custom SQL UDF DateTime Conversion

Completado Publicado Sep 1, 2004 Pagado a la entrega
Completado 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

Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL

Nº del proyecto: #3335782

Sobre el proyecto

4 propuestas Proyecto remoto Activo Sep 1, 2004

Adjudicado a:

SebastianSDS

See private message.

$7 USD en 1 día
(129 comentarios)
7.8

4 freelancers están ofertando un promedio de $8 por este trabajo

TakeRealUK

See private message.

$17 USD en 1 día
(551 comentarios)
6.7
devmaster11

See private message.

$17 USD en 1 día
(61 comentarios)
5.7
maramayvw

See private message.

$4.25 USD en 1 día
(94 comentarios)
5.5
johnmarkhowell

See private message.

$4.25 USD en 1 día
(20 comentarios)
4.8