Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Jul 2006
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    compare date type column

    is there anyway i can compare 3 or more date type column?

    let's say i have
    ------------------------------------------------
    date1 | date2 | date3
    ------------------------------------------------
    2006-06-01 | 2006-06-15 | 2006-09-19
    ------------------------------------------------

    can i just get the earliest date by command line?
    select XXXXX(date1,date2,date3) <--returns '2006-06-01 '
    select YYYYY(date1,date2,date3) <--returns '2006-09-19 '

    thanks

  • #2
    New to the CF scene
    Join Date
    Jul 2006
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    got the solution

    greatest and least are the functions

  • #3
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    Thanks for coming back to post the solution.


  •  

    Posting Permissions

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