Extracting month, day, year from a date field in MySQL DB
Posted: Wed Nov 02, 2005 11:04 pm
Hi All,
This is probably an easy one, but I just need to extract the numeric value for the month, day, and year of a MySQL Date/Time field. I'm an ASP convert, and in ASP you could simply use month(date), day(date), or year(date). Are there similar functions in PHP? I did google & search the php online manual and came up dry.
Thanks in advance!
This is probably an easy one, but I just need to extract the numeric value for the month, day, and year of a MySQL Date/Time field. I'm an ASP convert, and in ASP you could simply use month(date), day(date), or year(date). Are there similar functions in PHP? I did google & search the php online manual and came up dry.
Thanks in advance!