Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (29)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (27)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Write Date and Time Literals
How To Write Date and Time Literals? - Oracle DBA FAQ - Understanding SQL Basics
✍: FYIcenter.com
Date and time literals can coded as shown in the following samples:
SELECT DATE '2002-10-03' FROM DUAL -- ANSI date format 03-OCT-02 SELECT TIMESTAMP '1997-01-31 09:26:50.124' FROM DUAL 31-JAN-97 09.26.50.124000000 AM -- This is ANSI format
2007-04-24, 4287👍, 0💬
Related Topics:
Popular Posts:
What are the standard ways of parsing XML document? XML parser sits in between the XML document and ...
How To Set session.gc_maxlifetime Properly? - PHP Script Tips - Understanding and Using Sessions As ...
How do we get the current culture of the environment in windows and ASP.NET?
What is the difference between "printf(...)" and "sprintf(...)"? sprintf(...) writes data to the cha...
How To Truncate an Array? - PHP Script Tips - PHP Built-in Functions for Arrays If you want to remov...