å°String转æ¢æDateï¼æ¯ç±
æ°æ®åºç®¡çç³»ç»DMSï¼æ¯å¦ï¼MS_SQL,ORACLE,MY SQLï¼çå½æ°å®ç°çï¼æ以ä¸åçæ°æ®åºç®¡çç³»ç»çè¯å¥ä¼æå·®å¼ï¼ä¸é¢ä»¥å¸¸è§çms_sqlãoracleãmysql ç转æ¢æ¹æ³ä¸ºä¾ï¼
ms_sqlï¼
convert(datetime,'2010-11-13')
cast('2017-01-01' as datetime)
Oracle:
to_date('2017-01-01')
mysql:
date_format('2017-01-01','%Y-%c-%d')