RE: SQL Query that changes Epoch to Date

Thanks Randy -it looks exactly like what I want, nice and simple  & easy
to include in a SQL query!
Cheers
Steve

-----Original Message-----
From: Randy Clamons [mailto:[email protected]] 
Sent: Saturday, 25 November 2006 9:50 a.m.
To: Bonnett, John
Cc: Steve Bluck; [email protected]
Subject: Re: SQL Query that changes Epoch to Date

That sure looks like the long way around. Have you considered using the 
FROM_UNIXTIME function in MySql?

Randy Clamons
Systems Programming
[email protected]


Bonnett, John wrote:
> This might help 
> http://www.rebol.net/cookbook/recipes/0051.html
> 
> ______________
> 
> Carl Zeiss Vision
> Computer Scientist
> Asia Pacific
> 
> John Bonnett
> 
> 19 Cooroora Crescent
> Lonsdale SA 5160
> Australia
> 
> Phone: +61 (0) 8 8392 8366
> Fax: +61 (0) 8 8392 8400
> Email: [email protected]
> Web: www.vision.zeiss.com
> 
> This email, including any attachments, is intended for the sole use of
> the intended recipient(s) and may contain 
> information that is confidential, privileged and/or the sender's work.
> Any review or distribution by any other person is 
> prohibited. If you are not an intended recipient, please immediately
> contact the sender and delete all copies.
> 
> 
> -----Original Message-----
> From: Steve Bluck [mailto:[email protected]] 
> Sent: Friday, 24 November 2006 1:29 PM
> To: [email protected]
> Subject: SQL Query that changes Epoch to Date
> 
> Hi All,
> I've been volunteered to look after a MySQL 4.0.23 database (I know
it's
> old, but I thought I'd learn what I was doing before updating) which
> records dial-up radius users log details and all dates etc fileds in
the
> tables are in Epoch format. I'm relatively comfortable using SQL
queries
> to retrieve data but need to convert Epoch seconds to a 'me' friendly
> format to add meaning when debugging.
> Any help would be appreciated.
> Cheers
> Steve
> 
> 
> 

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]