Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Converting epoch times after 2038

by derby (Abbot)
on Apr 05, 2007 at 12:19 UTC ( [id://608463]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://608463]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others exploiting the Monastery: (2)
As of 2024-04-16 16:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found