CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2000date-conversion
McG369
McG369

Reputation: 172

SQL convert string to date format 112

I have an input date and I need to convert it to format 112 (yyyymmdd) for use later on in my SQL statement.

declare @day varchar(10)

set @day = '6/21/2013'

select @day

I've done this before...IDK if it's because I'm on SQL 2000 for this project that it's not working now.

Upvotes: 5

Views: 72609

Answers (2)

Asif Mahamud
Asif Mahamud

Reputation: 583

You can try this code from this novice user of this site.

declare @day varchar(10);

set @day = '6/21/2013';
select convert(date,@day,112);

Upvotes: 2

Taryn
Taryn

Reputation: 247810

I would convert it to a datetime first, then to the format that you want:

declare @day varchar(10)

set @day = '6/21/2013'

select convert(varchar(10), cast(@day as datetime), 112);

See SQL Fiddle with Demo

Upvotes: 9

Related Questions