[Resolved] converitng sysdate() to string in seconds

[itaym02]

Greetings

I have a column which stores the date of an action.
The format is string and in seconds.

How can I convert the sql function sysdate() to seconds and as a string.
Can it be done all in the sql, or do I need to use php for that.
(sql only is the prefered choice).

When I say second, I think it is seconds passed from the time php started counting, 1977 or somthing like that.

Thanks

[devinemke]

when storing dates/times, either use your RDBMS's native date format (like mySQL's DATE or DATETIME types) or use integers to store unix timestamps (seconds since 1970-01-01 00:00:00 GMT). use your RDBMS's built in functions to convert/format dates (like mySQL's Date and Time Functions).

[itaym02]

thanks

unix_timestamp() is the solution (a mysql function)