OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Julian Date

Tue, 09 July 2002 23:25

Shaharudin
Messages: 3
Registered: July 2002

Junior Member

How can I retrieve a result of date in standard (ex. 10/07/02)date not in julian date (ex. 102191)?

Wed, 10 July 2002 05:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> select TO_CHAR(to_date('12/14/02','MM/DD/YYYY'),'J') FROM DUAL;

TO_CHAR
-------
1722136

Wed, 10 July 2002 19:18

christopher
Messages: 25
Registered: September 2000

Junior Member

Yes you can.

SELECT to_char(datefield, 'MM/DD/YYYY') as column_alias
FROM table....

Previous Topic:	Setting up users
Next Topic:	Query to list the person who speaks every language !

Goto Forum:

]

Current Time: Thu Apr 18 22:40:09 CDT 2024