Home » SQL & PL/SQL » SQL & PL/SQL » date and time
date and time [message #351621] Wed, 01 October 2008 14:51 Go to next message
Messages: 2
Registered: September 2008
Junior Member
Hi all,

i want to insert into my table today's date automatically but the time of my choice.

can someone help me with this one?


Re: date and time [message #351623 is a reply to message #351621] Wed, 01 October 2008 14:53 Go to previous message
Michel Cadot
Messages: 63937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at TRUNC, TO_CHAR and TO_DATE functions.

Previous Topic: Help in explanation of this
Next Topic: Java Developer learning PL/SQL
Goto Forum:

Current Time: Thu Oct 27 19:46:42 CDT 2016

Total time taken to generate the page: 0.07651 seconds