Numbers to date time...

Dev Shed Forums Sponsor:

November 13th, 2012, 08:58 PM

narrokk

Contributing User

Join Date: Oct 2012

Posts: 31

Time spent in forums: 4 h 42 sec
Reputation Power: 1

Numbers to date time...

Is there any way to have numbers become a datetime? here is my code

declare @month as integer
declare @day as integer --1 or 16
declare @year as integer
declare @datefrom as varchar
set @month = 10
set @day = 1
set @year = 2012
set @datefrom = @month+'/'+@day+'/'+@year

select @datefrom

Ouput should be : 10/01/2012

but i get this error,

Server: Msg 245, Level 16, State 1, Line 10
Syntax error converting the varchar value '/' to a column of data type int.

could somebody help with me please

November 14th, 2012, 03:53 AM

swampBoogie

Contributing User

Join Date: Jan 2003

Location: Paris Uppland

Posts: 2,349

Time spent in forums: 1 Month 4 Days 7 h 27 m 6 sec
Reputation Power: 390

Code:

declare @datefrom as varchar(10)
set @month = 10
set @day = 1
set @year = 2012

set @datefrom = right('0' + cast(@month as varchar(2)),2) + '/' +
                right('0' + cast(@day as varchar(2)),2) + '/' + 
                right('000' + cast(@year as varchar(4)),4)

Note that you should specify a maximum length for the @datefrom variable.

You can also do

Code:

set @datefrom = convert(varchar(10),datefromparts(@year,@month,@day),101)

November 16th, 2012, 01:32 AM

narrokk

Contributing User

Join Date: Oct 2012

Posts: 31

Time spent in forums: 4 h 42 sec
Reputation Power: 1

Quote:

Originally Posted by swampBoogie

Code:

declare @datefrom as varchar(10)
set @month = 10
set @day = 1
set @year = 2012

set @datefrom = right('0' + cast(@month as varchar(2)),2) + '/' +
                right('0' + cast(@day as varchar(2)),2) + '/' + 
                right('000' + cast(@year as varchar(4)),4)

Note that you should specify a maximum length for the @datefrom variable.

You can also do

Code:

set @datefrom = convert(varchar(10),datefromparts(@year,@month,@day),101)

could i know the complete code? it seems like i'm missing the function datefromparts? have you declared it as a seperate variable? or is it a UDF(User Defined Function)?