skip to main | skip to sidebar

A coding life of Holst

Computer software is an unlimited world.

2009/06/17

GETDATE() in Oracle

MS SQL Server 取得伺服器時間很簡單地只要呼叫 GETDATE() 預設 function。那麼,Oracle 呢 ?
請執行這個語法

SELECT TO_CHAR(SYSDATE,'yyyy/MM/dd HH24:mi:ss') FROM dual;

執行結果為

2009/06/17 14:56:31

Posted by Unknown at 17:40 No comments:
Labels: Oracle, PL/SQL, SQL
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2018 (1)
    • ►  January (1)
  • ►  2015 (1)
    • ►  April (1)
  • ►  2014 (2)
    • ►  July (1)
    • ►  May (1)
  • ►  2013 (1)
    • ►  October (1)
  • ►  2012 (1)
    • ►  July (1)
  • ►  2011 (5)
    • ►  July (1)
    • ►  May (1)
    • ►  February (3)
  • ►  2010 (6)
    • ►  October (1)
    • ►  September (2)
    • ►  August (2)
    • ►  June (1)
  • ▼  2009 (6)
    • ►  October (1)
    • ►  August (1)
    • ►  July (3)
    • ▼  June (1)
      • GETDATE() in Oracle
  • ►  2008 (7)
    • ►  August (1)
    • ►  March (2)
    • ►  February (1)
    • ►  January (3)

About Me

Unknown
View my complete profile