RE: [PHP] mysql select and date functions

2003-02-18 Thread John W. Holmes
> Change your query: > selectdayofmonth(Posted) as DOM_Posted, > month(Posted) as M_Posted, > year(Posted)as Y_Posted, > hour(Posted) as HH_Posted, > minute(Posted) as MM_Posted, > Name, > Prayer > from pray

Re: [PHP] mysql select and date functions

2003-02-18 Thread Sunfire
tnx it worked just like i wanted it to... - Original Message - From: "Barajas, Arturo" <[EMAIL PROTECTED]> To: "'Sunfire'" <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 7:59 PM Subject: RE: [PHP] mysql select and date functions > Ha

RE: [PHP] mysql select and date functions

2003-02-18 Thread Bryan Lipscy
Change your query: select dayofmonth(Posted) as DOM_Posted, month(Posted) as M_Posted, year(Posted)as Y_Posted, hour(Posted) as HH_Posted, minute(Posted) as MM_Posted, Name, Prayer from prayer T

[PHP] mysql select and date functions

2003-02-18 Thread Sunfire
i have a field in a table called Posted and it is a timestamp type im using mysql and my page is supposed to take the timestamp field and show it on the screen in the form of month#/dayofmonth/year like 02/18/2003 the problem im having is trying to get it to be formatted.. i tried mysql functions l