Home » RDBMS Server » Server Administration » Re: help
Re: help [message #372690] Sat, 03 March 2001 06:14
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hai,

try this query,
select to_char(to_date(150,'j'),'jsp') from dual;

This is called Julian date format using this u can select upto 5373484 number.

Report message to a moderator

Previous Topic: Re: sql primer, date question
Next Topic: Help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 07:58:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.