Oracle timestamp in number format SQL [duplicate]

Question

I have my datetime column in table defined as Oracle NUMBER data type which contains data in this format 1363709957 for example.

I want to get these numbers in query so i can execute my insert scripts which will put in current time in there. What is the oracle SQL for that?

@Ben I do not want any conversion here. I just want the epoch time in oracle sql in NUMBER format. — Sripaul
– Sripaul, Commented Mar 26, 2013 at 9:28

Peter Wooster · Accepted Answer · 2013-03-25 12:03:23Z

2

Your time stamp appears to be a standard Unix time stamp. You need to use arithmetic to convert this here's a post on OTN about this,

and one for the other direction.

answered Mar 25, 2013 at 12:03

Peter Wooster

6,0882 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sripaul Over a year ago

I am using this SELECT (SYSDATE - TO_DATE('01-01-1970 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) * 24 * 60 * 60 FROM DUAL. But then it gives me values as 1364264318.999999999999999999999999999998 and not as whole number

Peter Wooster Over a year ago

This is normal floating point behavior. You can use the ROUND() function to make an integer of it. The INTEGER() function will truncate, so you need to round.

Collectives™ on Stack Overflow

Oracle timestamp in number format SQL [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related