#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2009
    Posts
    14
    Rep Power
    0

    Cast from datetime to date does nothing


    I am trying to cast datetime to date using the following

    select log.lid, cast(log.ldate as date), log.clid, log.staid, log.emid
    from tblclientlog_oes log

    Resulting date comes back as datetime. Is firebird cast broken and cannot distinguish a difference between date and datetime? if so, what would be some other ways to do it.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2007
    Posts
    36
    Rep Power
    8
    I have no problem to convert datetime to date this way.
    I tried both with IBExpert and with isql.
    How did you tried it?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2009
    Posts
    14
    Rep Power
    0
    Firebird version 1.5.
    IBexpert version 2005.06.07.

    1/18/2008 7:43:07 AM

    This is the resulting date after cast from datetime to date.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2007
    Posts
    36
    Rep Power
    8
    Originally Posted by summ0ner
    Firebird version 1.5.
    IBexpert version 2005.06.07.

    1/18/2008 7:43:07 AM

    This is the resulting date after cast from datetime to date.
    My version of Firebird is 2.1.3.
    Have you try it with isql from command line?

IMN logo majestic logo threadwatch logo seochat tools logo