Home » SQL & PL/SQL » SQL & PL/SQL » 'JSP' (Oracle 10g ,XP)
'JSP' [message #390718] Mon, 09 March 2009 07:35 Go to next message
rakeshramm
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;



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

Regards
Michel
Previous Topic: How to calcuate SGA
Next Topic: rename column
Goto Forum:
  


Current Time: Tue Feb 11 12:56:00 CST 2025