¼±£¬oracleתsql server - MS-SQL Server / ÒÉÄÑÎÊÌâ

oracleÖÐ
SQL code:
select to_timestamp('2010-04-16 16:52:04.093','YYYY-MM-DD HH24:MI:SS.FF3') from dual; ½á¹ûÊÇ£º16-APR-10 04.52.04.093000000 PM






ÈçºÎÔÚSQL SERVER ÖÐʵÏÖÕâÑùµÄ¹¦ÄÜ

ÓóÌÐò´¦ÀíÒ²¿ÉÒÔ£¬¼±ÆðÀ´Ã»Ë¼Â·À²

---

ÄãÊÇҪʵÏÖ¸ñʽ£¬»¹ÊÇÒªµ¼ÈëÒ»¸öʱ¼ä£¿

---

SQL code:

--convert×÷ÓãºÊ±¼äת×Ö·û´®
--120ÊÇÒ»ÖÖʱ¼ä¸ñʽ£¬¸ü¶à¸ñʽÇë°Ù¶Èconvert
select convert(varchar,getdate(),120)
--½á¹û
/*2010-04-16 19:15:36*/

---

SQL code:
--ÈÕÆÚת»»²ÎÊý,ÖµµÃÊÕ²Ø
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08

select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608

select CONVERT(varchar(12) , getdate(), 111 )
2004/09/12

select CONVERT(varchar(12) , getdate(), 112 )
20040912

select CONVERT(varchar(12) , getdate(), 102 )
2004.09.12

ÆäËüÎÒ²»³£ÓõÄÈÕÆÚ¸ñʽת»»·½·¨:

select CONVERT(varchar(12) , getdate(), 101 )
09/12/2004

select CONVERT(varchar(12) , getdate(), 103 )
12/09/2004

select CONVERT(varchar(12) , getdate(), 104 )
12.09.2004

select CONVERT(varchar(12) , getdate(), 105 )
12-09-2004

selec