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
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
Messages: 74
Registered: July 2000
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: Sun Jun 13 12:17:29 CDT 2021