Date Function

[lesstjm]

I want to update a field in a table to be today's date at 11:59pm. I guess I can't get the date to come out right. What arithmetic can I use to accomplish this?

[marist89]

system@dev815nt.us> l
1* select to_char(trunc(sysdate)+(((24*60*60)-1)/(24*60*60)), 'mm/dd/yyyy hh24:mi:ss') from dual
system@dev815nt.us> /

TO_CHAR(TRUNC(SYSDA
-------------------
02/20/2001 23:59:59