If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Unix timestamp and sql!

ConsultClifford · 2005-08-09 20:53:53

hi i have a date in a (mysql) db field as a Unix timestamp. eg 1121880568 (which is infact 20/07/2005) i know how to transform the former to the latter in php - date( 'd/m/Y',$row1->date) HOWEVER can anyone tell me how i could do so in the sql select statement IF possible ie something like this............ SELECT…

Options

09-08-2005 9:53pm

#1

ConsultClifford

Registered Users Posts: 252 ✭✭

Join Date: May 2003

Posts: 140

hi
i have a date in a (mysql) db field as a Unix timestamp.
eg 1121880568 (which is infact 20/07/2005)
i know how to transform the former to the latter in php
- date( 'd/m/Y',$row1->date)

HOWEVER
can anyone tell me how i could do so in the sql select statement IF possible ie
something like this............
SELECT DATE_FORMAT(date) AS created FROM.....................

im looking around and cant seem to find out how..........

Tnx

0

Comments

Options
#2 09-08-2005 10:08pm
dahamsta

Banned (with Prison Access) Posts: 16,659 ✭✭✭✭

Join Date: October 2000

Posts: 15270

See UNIX_TIMESTAMP.

0
Options
#3 09-08-2005 10:18pm
ConsultClifford

Registered Users Posts: 252 ✭✭

Join Date: May 2003

Posts: 140

dahamsta wrote:

See UNIX_TIMESTAMP.

was not quite that
was FROM_UNIXTIME function.

you pointed me in the right anyhow cheers.

0
Options
#4 09-08-2005 11:14pm
dahamsta

Banned (with Prison Access) Posts: 16,659 ✭✭✭✭

Join Date: October 2000

Posts: 15270

ConsultClifford wrote:

was not quite that

Actually it is. You're just using another function for the same purpose.

0