SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: How can I select hour, minute, second from a date field in oracle

  1. Jun 8, 2004 22:32 #1
    Angry Coder
    Angry Coder is offline
    SitePoint Guru Angry Coder's Avatar
    Join Date
    May 2002
    Location
    Canada
    Posts
    601
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How can I select hour, minute, second from a date field in oracle

    Hello,

    I think the title says... When I select it normally it only returns the day/month/year.

    Thank you.
    Why It Doesn't Work?!
  2. Jun 8, 2004 22:33 #2
    Angry Coder
    Angry Coder is offline
    SitePoint Guru Angry Coder's Avatar
    Join Date
    May 2002
    Location
    Canada
    Posts
    601
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh... I am talking about Oracle.
    Why It Doesn't Work?!
  3. Jun 9, 2004 06:44 #3
    MattR
    MattR is offline
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Look-up the TO_CHAR format in the documentation.
    Matt - Sybase DBA / PHP fanatic
    Sybase/MySQL/Oracle | I don't like MySQL
    Download Sybase | DBForums.com - for all your RDBMS talk
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules