Support Forums: Message List - How best to persist / model dates with CMP?http://www.theserverside.com
Most recent forum messagesenJive Forums Silver 5.5.30 (www.jivesoftware.com)Sun, 02 Aug 2015 16:51:15 -0400reviise sqlhttp://www.theserverside.com/discussions/thread.tss?thread_id=25257
Fri, 16 Apr 2004 11:22:17 -0400Fri, 16 Apr 2004 11:22:17 -0400Fri, 16 Apr 2004 11:22:17 -0400Apr 16, 2004Michael Malkinzon0java.sql.Date is date and timehttp://www.theserverside.com/discussions/thread.tss?thread_id=25257
java.sql.Date is date and time. The Long is number of milliseconds from 1972. The java.sql.Date will make it easier to query db directly as well, since you can write an sql like this

SELECT * from MyTable...]]>Fri, 16 Apr 2004 11:21:06 -0400Fri, 16 Apr 2004 11:21:06 -0400Fri, 16 Apr 2004 11:21:06 -0400Apr 16, 2004Michael Malkinzon1How best to persist / model dates with CMP?http://www.theserverside.com/discussions/thread.tss?thread_id=25257
Thanks for your replies. My dates need to store the time, not just the date. I then also need to be able to do sql where clauses based on date inclusions.