Can someone give me a simple way to format a data entry from dd/mm/yyyy to dd/mm/yy? Thanks!

Tad

this date format in C# or SQLSERVER

Here you go. _________________________
- Vijay G
Strive for Perfection

Thanks for the help. This is not a system date but a data entry in the mm/dd/yyyy format that I need to convert to mm/dd/yy. I have tried using the convert string function but unsuccessfully.


Tad

I understand, since it was not mentioned in the original post if that was a variable or a column name or something else that you try to convert, I just gave you the example with GETDATE(). Moreover, no clue about if you are trying to do that from sql server or from the front end application, though it was posted under sql server forum, thought I will post the example in t-sql.

Cheers.

_________________________
- Vijay G
Strive for Perfection

It is in SQL SERVER and I'm trying to script it during a runtime commmand. Our application fails when the data is in the mm/dd/yyyy format.

Tad

I finally figured it out. If anyone needs it:

UPDATE [Table_Name]
          SET [Column_Name1] = CONVERT(CHAR(4),[Column_Name1])+ RIGHT([Column_Name1],2)

Tad

What datatype is your column_name1?

_________________________
- Vijay G
Strive for Perfection

I think I see why you ask, varchar. I could have used LEFT(). But now I have another issue. I have been working on a date that is 5/6/2007. What if I get 12/12/2007? Is there a way to remove the last four characters of a string? So, I could go...
(function for removing right 4 characters of string) + RIGHT()

Tad

So, this ended up being a string manipulation using a CASE statement. If anyone knows how to do this differently using a date format, I'd like to know. Thanks for the help Vijay!

Tad