update date format

[camy123]

hi how would i update a table and change the date from
mm/yyyy format to yyyy/mm format

 

[donutman]

Store the data as datetime (1st of month) and you won't have that issue.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[SQLBill]

Dates really should be stored as DATETIME values. But if you really have to store it your way, use SUBSTRING to grab each portion.

SELECT SUBSTRING(colname, 4, 7) + '/' + SUBSTRING(colname, 1, 2).

-SQLBill

Posting advice: FAQ481-4875

 

[ESquared]

Note that the convert function can accept a style parameter when converting from datetime as well as converting to it. When converting to it, the style determines what the mdy order is for the character data.

-------------------------------------
• Every joy is beyond all others. The fruit we are eating is always the best fruit of all.
• It is waking that understands sleep and not sleep that understands waking. There is an ignorance of evil that comes from being young: there is a darker ignorance that comes from doing it, as men by sleeping lose the k