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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date convert problem 2

Status
Not open for further replies.
webfuture

webfuture

MIS
Jan 17, 2003
65
CA
Hi all,

I am trying to convert a numeric value of 38142 for example to a date. This value is the number of days since 1/1/1900.

I have tried many thing with to_date, cast... and it did not work.

Anyone have tips for me.

Thanks,
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
2K
EM1107
EM1107
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
266
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top