How can i convert UK date format to US ?

[febinjs6]

can any one help me in doing this?....

In ma project i have to generate a datepicker using JQuery when clicking on a textbox ? So far its fine for me ....I've generated Successfully but the problem starts now ....I am supposed to display the date in UK format in the View part but I have to save in the database in the US format that i don't know? So if u peoples know anything pls help me....

Thanks and regards,
Febin

[Hydaral]

Databases don't have a specific date format, the format is defined by whatever formatting you use in the front-end application.

As a general rule, for any date operations I do with any database, I always use the ISO date format. All databases will accept this and it is non-ambiguous.

Display date: 7 August 2010, 7:52 AM
ISO date: 2010-08-07 19:52

You can see that is is YYYY-MM-DD HH:MM:SS

Always convert your date to ISO format before passing it to your database and you should never have a problem.

For reference, the US date format is: MM/DD/YYYY

They are the only country in the world which uses this format:

http://en.wikipedia.org/wiki/Date_an...ion_by_country

Strangely enough, China is the only country that uses the ISO format as their country format.

[MMcCarthy]

Hydaral Databases don't have a specific date format

Just one small clarification :) MS Access does have a date format. It imposes the US date format for some strange reason.