Programming Forums > Web Development and Design > PHP

guess · Mar 10th, 2006, 3:46 AM

while creating a data field in a table in mysql, I want to format the date like

dd/mm/yyyy . But I have to alter the table...Can anyone write the query here??

tempest · Mar 10th, 2006, 5:16 PM

Huh? You're going to have to give us more information, your namesake is very fitting btw...

Ooble · Mar 10th, 2006, 5:40 PM

When you select the date from the table, use the DATE_FORMAT function:

(Toggle Plain Text)

SELECT DATE_FORMAT(my_date, '%d %m %Y') FROM my_table

Mar 10th, 2006, 3:46 AM	#1
guess Programmer Join Date: Feb 2006 Posts: 40 Rep Power: 0	date format while creating a data field in a table in mysql, I want to format the date like dd/mm/yyyy . But I have to alter the table...Can anyone write the query here??

Mar 10th, 2006, 5:16 PM	#2
tempest Programming Guru Join Date: Oct 2004 Posts: 1,041 Rep Power: 5	Huh? You're going to have to give us more information, your namesake is very fitting btw... __________________

Mar 10th, 2006, 5:40 PM	#3
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	When you select the date from the table, use the DATE_FORMAT function: (Toggle Plain Text) SELECT DATE_FORMAT(my_date, '%d %m %Y') FROM my_table SELECT DATE_FORMAT(my_date, '%d %m %Y') FROM my_table __________________ Me :: You :: Them

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

date format