String and Datetime transform each other

MSSqlserver:

 1. Convert string to datetime

cast(‘2015-08-26‘ as datetime) or convert(datetime,‘2015-08-26‘)

2. Convert string to datetime

Oracle:

1. Convert string to datetime

TO_DATE(yourdate,‘YYYY-MM-D HH24:MI:SS‘);  Ex: select to_date(‘2010-01-01‘) from dual

T0_CHAR(yourdate,‘YYYY-MM-D HH24:MI:SS‘);

2. Convert string to datetime

String and Datetime transform each other

原文：http://www.cnblogs.com/ganting/p/4782464.html