[prasharry2k5]

I am working on mysql and need to know how to use the datetime datatype in such a way that i get only date displayed and not time and also i want the date to be in dd/mm/yyyy format. Plz tell me how to use this feature and get what i want.

[Advertisements]

Hello prasharry2k5,

Could you please explain why you're trying to use the DATETIME type if you only want the date? The following piece of code will give you the current date in the format that you asked..

SELECT date_format(CurDate(), '%d/%m/%y')

Alternately, if you're trying to access a date from a table:

SELECT date_format(column, '%d/%m/%y') FROM table

Since you didn't really specify what you were trying to access / why, I'm afraid that's the best I can offer.

- Dan

[Dan]

Hello prasharry2k5,

Could you please explain why you're trying to use the DATETIME type if you only want the date? The following piece of code will give you the current date in the format that you asked..

SELECT date_format(CurDate(), '%d/%m/%y')

Alternately, if you're trying to access a date from a table:

SELECT date_format(column, '%d/%m/%y') FROM table

Since you didn't really specify what you were trying to access / why, I'm afraid that's the best I can offer.

- Dan