varchar to date format

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

bkDBA Ten Centuries Points: 1320 More actions · Answer 1

Just use the normal cast, then modify the datetime to fit whatever format you need:

select cast('October 02 2008' as datetime)

The full command is:

select convert(varchar(30),cast('October 02 2008' as datetime),101)

_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 2

Thanks for the quick reply...

Can i use that column name.I want to convert all the values from that column..

bkDBA Ten Centuries Points: 1320 More actions · Answer 3

Yes, you should be able to...but try it out.

In fact, the date doesn't even need to be fully formatted:

select convert(varchar(30),cast('Oct 2 08' as datetime),101)

_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 4

How can i execute the same for a particular column.I want to convert all the the values in that particular coulmn

bkDBA Ten Centuries Points: 1320 More actions · Answer 5

Ratheesh.K.Nair (10/17/2008)
How can i execute the same for a particular column.I want to convert all the the values in that particular coulmn

select convert(varchar(30),cast(MyLongDateField as datetime),101) from MyTable

_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees