Posted by ZeldorBlat on 10/10/05 06:51

If your database column is a datetime type (probably is, since you used
NOW() to poplulate it), just select it as follows:

SELECT UNIX_TIMESTAMP(myCol)
FROM myTable

Use the result (which will be the time represented in UNIX timestamp
format) as the second parameter to strftime().

[Back to original message]