Question

sql语句里怎么将String转换成Date

sql语句里怎么将String转换成Date

Answer 1

MSSqlserver：
cast('2010-01-01' as datetime)或convert(datetime,'2010-01-01')

Oracle:
to_date('2010-01-01')

Answer 2

MSSqlserver：
select cast('2010-01-01' as datetime)或select convert(datetime,'2010-01-01')

Oracle:
select to_date('2010-01-01') from dual.