Oracle

INSERT sql statement for DateTime

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 53

Reputation: dotNetDummi is an unknown quantity at this point

Solved Threads: 0

dotNetDummi dotNetDummi is offline

Offline

Junior Poster in Training

INSERT sql statement for DateTime

Oct 15th, 2009

Hi all,

Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed.

For example,
Insert into xxx
Values(current_date + '12:00:00');

Anyone have any idea if SQL allows this?

I look forward to your reply.
Thanks in advance.

Serene Joey

•

Join Date: Feb 2007

Posts: 2,103

Reputation: debasisdas will become famous soon enough

Solved Threads: 128

debasisdas debasisdas is offline

Offline

Postaholic

Oct 16th, 2009

you can always do that , just use sysdate that will handle your date problem.

Share your Knowledge.

•

Join Date: Sep 2008

Posts: 118

Reputation: cgyrob is on a distinguished road

Solved Threads: 18

cgyrob

Offline

Junior Poster

Oct 16th, 2009

You can use this to get current date at midnight.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT to_char (trunc(SYSDATE), 'MM-DD-YYYY HH:MI:SS') FROM dual;
Select to_char (trunc(SYSDATE), 'MM-DD-YYYY HH:MI:SS') from dual;