Hello, I'm using the TCL binding of sqlite3 One of the columns in my table has a date and time stamp, something like this:
07/20/2004 01:35:40 06/20/2005 01:37:01 06/20/2005 12:10:07 06/20/2005 12:17:08 06/20/2005 01:35:00 If I want to get all dates that are later than "06/20/2005 01:00:00" I might try: "select c1 from t1 where c1 > '06/20/2005 01:35:00'" But that also returns All the above including "07/20/2004 01:35:40" because (I suppose) comparison starts from the left and it sees 07 which is > than 06. Any ideas or hints in general where I can get the dates that I'm looking for? Thanks The information transmitted is intended only for the person(s)or entity to which it is addressed and may contain confidential and/or legally privileged material. Delivery of this message to any person other than the intended recipient(s) is not intended in any way to waive privilege or confidentiality. Any review, retransmission, dissemination or other use of , or taking of any action in reliance upon, this information by entities other than the intended recipient is prohibited. If you receive this in error, please contact the sender and delete the material from any computer. For Translation: http://www.baxter.com/email_disclaimer