Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Location
    Barcelona
    Posts
    42

    Question Unanswered: Migrating DATETIME to Oracle



    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.



  2. #2
    Join Date
    Jan 2004
    Posts
    492
    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
    Oracle OCPI (Certified Practicing Idiot)

  3. #3
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    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);

  4. #4
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Isn't that more likely an INTERVAL '00:00' HOUR TO MINUTE datatype ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •