MySql timestamp

[philb]

Question: is the mysql timestamp the same as the unix epoch? because ive been entering dates into my db and its returning the wrong dates and the year 1969! woohoo........
anyway, if it isnt the same as unix epoch what format do i enter it as? and if it is... what the hell is going on?!?!?

Thank you

[bretticus]

No, a true unix timestamp is number of seconds from Jan 1, 1970. MySQL timestamp is actually a formatted date - YYYYMMDDHHMMSS

[Anon]

use the UNIX_TIMESTAMP function in SQL to get the time, like

SELECT UNIX_TIMESTAMP(datetime) as datetime FROM table

[philb]

thank you... also, i need to be able to select specific records based on the month in a datetime field. How can i specify that?
Here is my imaginary code to describe what im looking for:

"SELECT * FROM Table1
WHERE month(dtField) = 'a month'"

its obvious that that isnt the code but it describes the result i want. thanks for your help!

[philb]

Also, how do you format the time from a MySql datetime field? Ive tried date() and strftime() but they dont seem to understand whats being inputed and return an entirely different date... Thanks...

[philb]

...