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().

• Next in forum: Re: Exception Class Question -> getLine()
• Prev in forum: Convert NOW() into PHP timestamp
• Thread view: Re: Convert NOW() into PHP timestamp

[Reply to this message]