Home » SQL & PL/SQL » SQL & PL/SQL » Time Isolation and Setting
Time Isolation and Setting [message #35878] Mon, 22 October 2001 02:06 Go to next message
Craig
Messages: 28
Registered: October 2001
Junior Member
Does anyone know how I can set the time to midnight?

EG TODAY := TO_CHAR(SYSDATE,'HH24:MI:SS'); Only I want to set 'HH24:MI:SS' to '00:00'.

Many thanks for any help.

----------------------------------------------------------------------
Re: Time Isolation and Setting [message #35882 is a reply to message #35878] Mon, 22 October 2001 04:52 Go to previous message
jim
Messages: 74
Registered: July 2000
Member
to_char(trunc(sysdate),'YYYY-MM-DD HH24:MI:SS')

----------------------------------------------------------------------
Previous Topic: Re: converting a pl/sql rocedure into an exe file or any OS file
Next Topic: urgent
Goto Forum:
  


Current Time: Mon Feb 24 15:44:09 CST 2020