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/win32?unsub=3Dgcdmw-win32@m.gmane.org

RE: SQL Query that changes Epoch to Date

This might help=20
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: john.bonnett@vision.zeiss.com
Web: www.vision.zeiss.com

This email, including any attachments, is intended for the sole use of
the intended recipient(s) and may contain=20
information that is confidential, privileged and/or the sender's work.
Any review or distribution by any other person is=20
prohibited. If you are not an intended recipient, please immediately
contact the sender and delete all copies.


-----Original Message-----
From: Steve Bluck [mailto:steve@staff.inhb.co.nz]=20
Sent: Friday, 24 November 2006 1:29 PM
To: win32@lists.mysql.com
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/win32?unsub=3Dgcdmw-win32@m.gmane.org

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
randy@novaspace.com


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: john.bonnett@vision.zeiss.com
> 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:steve@staff.inhb.co.nz]
> Sent: Friday, 24 November 2006 1:29 PM
> To: win32@lists.mysql.com
> 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/win32?unsub=gcdmw-win32@m.gmane.org

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:randy@novaspace.com]=20
Sent: Saturday, 25 November 2006 9:50 a.m.
To: Bonnett, John
Cc: Steve Bluck; win32@lists.mysql.com
Subject: Re: SQL Query that changes Epoch to Date

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

Randy Clamons
Systems Programming
randy@novaspace.com


Bonnett, John wrote:
> This might help=20
> http://www.rebol.net/cookbook/recipes/0051.html
>=20
> ______________
>=20
> Carl Zeiss Vision
> Computer Scientist
> Asia Pacific
>=20
> John Bonnett
>=20
> 19 Cooroora Crescent
> Lonsdale SA 5160
> Australia
>=20
> Phone: +61 (0) 8 8392 8366
> Fax: +61 (0) 8 8392 8400
> Email: john.bonnett@vision.zeiss.com
> Web: www.vision.zeiss.com
>=20
> This email, including any attachments, is intended for the sole use of
> the intended recipient(s) and may contain=20
> information that is confidential, privileged and/or the sender's work.
> Any review or distribution by any other person is=20
> prohibited. If you are not an intended recipient, please immediately
> contact the sender and delete all copies.
>=20
>=20
> -----Original Message-----
> From: Steve Bluck [mailto:steve@staff.inhb.co.nz]=20
> Sent: Friday, 24 November 2006 1:29 PM
> To: win32@lists.mysql.com
> Subject: SQL Query that changes Epoch to Date
>=20
> 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
>=20
>=20
>=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org