convert char to datetime

[Guest_imported]

Have a requirement to:

Convert char(7) YYYY-MM variable (eg. '2001-07') to both:
datetime '2001-07-01 00:00:00.000' and
datetime '2001-07-01 23:59:59.997'

thx in advance!

 

[foxdev]

[tt]cast (@MyVariable + '-01 00:00' as datetime) [/tt]
Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com