Unix timestamp to month Problem

[wildmurphy]

Hi all,

Im having trouble using mysql to select a unix timestamp from a database and return a month as the field.....

SELECT hdr.incident_id as Incident_ID , hdr.incident_date as Incident_Date .....

needing to get the hdr.incident_date which is a unix timestamp to return Incident_date as just the month in the word format ie december.......

Argh!! PLease help me

 

[JustKIDn]

Try this;

http://www.mysql.com/doc/en/Date_and_time_functions.html

Does that help?
tgus

____________________________
Families can be together forever...

 

[QatQat]

select monthname(Name_Of_the_unixtimestamp) from table


Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)