srodgers45
asked on
Convert date string to datetime
I have a date and time field I need to convert to true date time field.
This works but is not recognized at a datetime field with I apply other formulas to it for filtering, such as previous month data, etc...
atsdate + ' ' + atstime AS AtScene
returns this value:
2009-10-30 21:15:00
Still a string, not datetime
I am using SQL 2005 and SSRS 2008r2
Thanks in advance
This works but is not recognized at a datetime field with I apply other formulas to it for filtering, such as previous month data, etc...
atsdate + ' ' + atstime AS AtScene
returns this value:
2009-10-30 21:15:00
Still a string, not datetime
I am using SQL 2005 and SSRS 2008r2
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please keep in mind that if either the atsdate or atstime do not combine into a valid datetime, SQL Server will let you know about it with an error message that it could not convert an invalid date/time string.
ASKER
Thank you for the assistance