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
MicheChekra
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?

thanks,

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: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at TRUNC, TO_CHAR and TO_DATE functions.

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


Current Time: Wed Dec 07 05:17:02 CST 2016

Total time taken to generate the page: 0.20886 seconds