Numberic to Date function 1

[JBaileys]

This seems extremely simple - but I am fumbling on a Monday morning...

I have fields transyear, transmonth and transday. They are all numeric. If I want to display a date field how would I go about it.

Select transyear +'/'+ transmonth +'/' + transday

 

[TheJon]

Try this, it works for me in the UK.
[tt]
select convert(datetime, str(transyear) + '-' + str(transmonth) + '-' + str(transday))
[/tt]

|_ |_  _  | _  _
|, | )(/, |(_)| )
          '

 

[dreameR25]

select convert(datetime, '20040419', 112) -- using dat format YYYYMMDD