Varchar to Date SQL SERVER

Topic

New Reply

Hi folks, am a newbie to SQL server and finding it difficult to convert a varchar field to date (was easy in Access!)

I have a field in Table1 called Opened which gives a string dd/mm/yyyy in varchar (10) format.

I wish to convert this to date and have tried various methods all of which don’t work. e.g.

ALTER[/COLOR][/SIZE] TABLE[/COLOR][/SIZE] dbo.[/COLOR][/SIZE]Table1
ALTER[/COLOR][/SIZE] COLUMN[/COLOR][/SIZE] OPENED date

I have also tried CONVERT CAST without success.

I’m sure its easy when you know how – can anyone help?

Thanks so much

blitz[/COLOR][/SIZE]

Reply | Quote

Replies

You want to convert it to a Date to insert in a table or just to perform some calculation?

Reply | Quote

You want to convert it to a Date to insert in a table or just to perform some calculation?

Hi I am going to search for records between dates.

thanks.

Reply | Quote

You can use

Code:

[FONT font="Courier New"][COLOR=fuchsia]convert[/COLOR][COLOR=gray]([/COLOR][COLOR=blue]datetime[/COLOR][COLOR=gray],[/COLOR] [COLOR=red]YourDateValueAsAString[/COLOR][COLOR=gray],[/COLOR]103[COLOR=gray])

[/COLOR][/FONT]

Reply | Quote