Very Computer

by **George Durz** » Fri, 24 Oct 2003 22:19:10

I wanted to check if anyone had written a UDF or some SQL to convert Unix
Epoch time to "human" time before I went ahead and tried.

Thanks!

by **Steve Kas** » Fri, 24 Oct 2003 22:47:33

George,

It's a simple addition of seconds to the Unix epoch base
moment:

select

dateadd(second,1066012345,'19700101') as HumanTime

If you need local time, add your offset from Universal
Coordinated Time.

-- Steve Kass
-- Drew University
-- Ref: 4207C042-C4BA-4EC5-8161-B27ADEB662AD

>I wanted to check if anyone had written a UDF or some SQL to convert Unix
>Epoch time to "human" time before I went ahead and tried.

>Thanks!

by **George Durz** » Fri, 24 Oct 2003 22:52:14

Steve,
Where did you come up with 1066012345?
Was it arbitrary?

> George,

> It's a simple addition of seconds to the Unix epoch base
> moment:

> select

> dateadd(second,1066012345,'19700101') as HumanTime

> If you need local time, add your offset from Universal
> Coordinated Time.

> -- Steve Kass
> -- Drew University
> -- Ref: 4207C042-C4BA-4EC5-8161-B27ADEB662AD

> >I wanted to check if anyone had written a UDF or some SQL to convert Unix
> >Epoch time to "human" time before I went ahead and tried.

> >Thanks!

by **George Durz** » Fri, 24 Oct 2003 22:56:49

Pls ignore last question, now I get it :)
Thanks for your response steve

> Steve,
> Where did you come up with 1066012345?
> Was it arbitrary?

> > George,

> > It's a simple addition of seconds to the Unix epoch base
> > moment:

> > select

> > dateadd(second,1066012345,'19700101') as HumanTime

> > If you need local time, add your offset from Universal
> > Coordinated Time.

> > -- Steve Kass
> > -- Drew University
> > -- Ref: 4207C042-C4BA-4EC5-8161-B27ADEB662AD

> > >I wanted to check if anyone had written a UDF or some SQL to convert
Unix
> > >Epoch time to "human" time before I went ahead and tried.

> > >Thanks!

by **Steve Kas** » Fri, 24 Oct 2003 22:59:34

I just wanted a time around now, and I changed the last few digits of "now".

SK

>Steve,
>Where did you come up with 1066012345?
>Was it arbitrary?

>>George,

>> It's a simple addition of seconds to the Unix epoch base
>>moment:

>>select

>> dateadd(second,1066012345,'19700101') as HumanTime

>>If you need local time, add your offset from Universal
>>Coordinated Time.

>>-- Steve Kass
>>-- Drew University
>>-- Ref: 4207C042-C4BA-4EC5-8161-B27ADEB662AD

>>>I wanted to check if anyone had written a UDF or some SQL to convert Unix
>>>Epoch time to "human" time before I went ahead and tried.

>>>Thanks!

Unix Epoch Time