SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Guru Angry Coder's Avatar
    Join Date
    May 2002
    Location
    Canada
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Does the DATE column type accepts the hour and the minute?

    If so, how?

    Please help me.

    Thank you...
    Why It Doesn't Work?!

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    probably not

    you didn't say which database
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Guru Angry Coder's Avatar
    Join Date
    May 2002
    Location
    Canada
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks...

    The database is: Oracle.

    I asked someone here at work, and he says it does. But I don't know how to insert and select it

    Please help me I have a delayed project
    Why It Doesn't Work?!

  4. #4
    SitePoint Member sukrish's Avatar
    Join Date
    May 2004
    Location
    India
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,
    lets try to convert the value using to_date(datestring,"dd-MM-yyyy hh:mi AMPM")

    hope it will work


    regards
    Sukrish



    Quote Originally Posted by Angry Coder
    Thanks...

    The database is: Oracle.

    I asked someone here at work, and he says it does. But I don't know how to insert and select it

    Please help me I have a delayed project

  5. #5
    SitePoint Guru Angry Coder's Avatar
    Join Date
    May 2002
    Location
    Canada
    Posts
    599
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It did, maaany thanks...

    I have another question

    How can I compare 2 dates?
    Why It Doesn't Work?!

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    select foo from bar where date1 > date2
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •