Home » SQL & PL/SQL » SQL & PL/SQL » 'JSP' (Oracle 10g ,XP)
'JSP' [message #390718] Mon, 09 March 2009 07:35 Go to next message
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

Hi all i like to know the working of this query .I know that 'J' stands for Julian .Please explain about its working .

select to_char(to_date(873,'J'), 'JSP') as converted_form from dual;

Re: 'JSP' [message #390721 is a reply to message #390718] Mon, 09 March 2009 07:52 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference
Section Datetime Format Models

Previous Topic: ORA-02019: connection description for remote database not found
Next Topic: rename column
Goto Forum:

Current Time: Sun Aug 20 16:15:31 CDT 2017

Total time taken to generate the page: 0.05650 seconds