var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Migrating DATETIME to Oracle
I would like to know how next Infomix SPL sentence would be in
LET m_diaini = DATETIME(00:00) HOUR TO MINUTE;
Give an example with an exact time - what would the output of that be in Informix?
Off the top of my head, my guess would be:
m_diani := to_char(sysdate, 'HH24:MI'); --24 hour clock
m_diani := to_char(sysdate, 'HH:MI PM'); --12 hour AM/PM clock
Oracle OCPI (Certified Practicing Idiot)
If you want to declare a DATE variable in Oracle and initialise it to today's date at 00:00:00, then perhaps
v_diani DATE := TRUNC(SYSDATE);
Isn't that more likely an INTERVAL '00:00' HOUR TO MINUTE datatype ?