Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How Many Ways to Get the Current Time
How Many Ways to Get the Current Time? - MySQL FAQs - Introduction to SQL Date and Time Handling
✍: FYIcenter.com
There are 8 ways to get the current time:
SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql> SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELECT LOCALTIME() FROM DUAL; 2006-07-01 10:07:37 mysql> SELECT LOCALTIMESTAMP() FROM DUAL; 2006-07-01 10:08:08 mysql> SELECT UTC_TIME() FROM DUAL; 14:09:22 mysql> SELECT UTC_TIMESTAMP() FROM DUAL; 2006-07-01 14:09:49
2007-05-11, 4830👍, 0💬
Popular Posts:
Why is it preferred to not use finalize for clean up? Problem with finalize is that garbage collecti...
What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...
How can method defined in multiple base classes with same name be invoked from derived class simulta...
How do we access attributes using “XmlReader”? Below snippets shows the way to access attributes. Fi...
How to create arrays in JavaScript? We can declare an array like this var scripts = new Array(); We ...