Migrating DATETIME to Oracle

dvtdbd · #1 (**permalink**) 01-19-06, 04:38

I would like to know how next Infomix SPL sentence would be in
Oracle PL/SQL:

LET m_diaini = DATETIME(00:00) HOUR TO MINUTE;

Thanks.

ss659 · #2 (**permalink**) 01-19-06, 09:01

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:

Code:

m_diani := to_char(sysdate, 'HH24:MI'); --24 hour clock
m_diani := to_char(sysdate, 'HH:MI PM'); --12 hour AM/PM clock

WilliamR · #3 (**permalink**) 01-21-06, 11:39

If you want to declare a DATE variable in Oracle and initialise it to today's date at 00:00:00, then perhaps

DECLARE
v_diani DATE := TRUNC(SYSDATE);

JMartinez · #4 (**permalink**) 01-22-06, 11:22

Isn't that more likely an INTERVAL '00:00' HOUR TO MINUTE datatype ?