Tags: database, dual, likeselect, mysql, oracle, select, sql, time, time_now

select time from dual

On Database » Oracle

247 words with 2 Comments; publish: Wed, 13 Feb 2008 22:35:00 GMT; (25048.83, « »)

how do I select the time, I mean, something like:

select time_now from dual;

All Comments

Leave a comment...

  • 2 Comments
    • SQL> select to_char(sysdate,'hh24:mi:ss') from dual;
      TO_CHAR(
      --
      10:47:20
      1 rij is geselecteerd.

      Regards,

      Rob.

      #1; Sat, 23 Feb 2008 15:59:00 GMT