how to change date format

[prasannagps]

hi All,

i want to Date format "dd/mm/yyyy"?


Thanks & Regards.

G.prasad

[Imar]

Hi there,

I think it would really help if you:

a) posted in the right forum, applicable to the technology you're working with. This forum is for general feed back about the forum, not for technical questions.

b) specify the language you're working with. Right now, it's impossible to do a suggestion.

Did you google for this? Usually, something like "date format" YourTechnology brings up a lot of useful results.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

[kanu75]

Hi

use the format option in sql statement

sSql = " SELECT Format(dateField.date, 'dd-mm-yyyy') as dateformatted,"



result would be <%=dateformatted%> dd/mm/yyyy

kanu