in reply to Converting epoch times after 2038

I query a Sybase database and get the date back in epoch format

Why don't you let Sybase do the conversion for you: 

  select convert(varchar(12), mydate, 3) from table

[download]
That will convert a date file into Sybase's format 3 which is dd/mm/yy. here's the list of formats.

-derby

Replies are listed 'Best First'.
Re^2: Converting epoch times after 2038
by kurre_vaxholm (Acolyte) on Apr 10, 2007 at 07:04 UTC
    Hi derby. Well I have built a framwork where you can define your dateformat and alot of other formats for floats integers etc, in a template. If I shall be able to easily redefine my dateformat it needs to be in epoch since that's what strftime uses. But right now i have decided to convert the date in the sp and redo my frame when I have the time. Cheers
[reply]

In Section Seekers of Perl Wisdom