Re: Date in SQLServer

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Nov 20 2003 - 12:50:41 EST

  • Next message: Andrus Adamchik: "Re: Flushing new/dirty Objects before Query"

    On Nov 20, 2003, at 9:15 AM, Leonardo R. Nunes wrote:

    > Hello,
    >
    > There isn’t a type DATE in MS-SQLServer, just the type DATETIME.

    > Do you have some suggestion about the better way to use dates
    > (java.util.Date:) with MS-SQLServer??
    >
    > Regards,
    > Leonardo.

    Hi Leonardo,

    SQLServer DATETIME would be best mapped in Cayenne as "TIMESTAMP"
    (standard JDBC type for this kind of dates). On the Java side you can
    use java.util.Date (which Cayenne would do by default anyway), it
    should work just fine.

    Andrus

    This archive was generated by hypermail 2.0.0 : Thu Nov 20 2003 - 12:50:45 EST