Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert a date in a number

Status
Not open for further replies.
claude69

claude69

Technical User
Jan 30, 2003
15
0
0
IN
Hi guys, I need to convert a series of Date in a sequence of number, there is someone that have a script precompiled.
Thanks
 
Sort by date Sort by votes
Use Julian dates, see function TO_CHAR in SQL Reference documentation.

Example:
SELECT TO_NUMBER(TO_CHAR (hire_date, 'J')) FROM employees;
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Format a number - TO_CHAR() 2
Replies
5
Views
208
SkipVought
S
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
157
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
176
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
1K
carp
carp
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
211
carp
carp

Part and Inventory Search

Sponsor

Back
Top