Skip to Content
Former Member
Feb 09, 2007 at 03:57 PM

How do I query using a Date field?


Can anyone tell me the best way to do the following:

I have a database that contains a timestamp field (the format looks like this: 2006-12-04 13:45:34:0). I want the user to be able to input a date, and I will then insert that date into an SQL statement to output the information for that date shown.

I have a datepicker control that I am using on the input form, then that date should be matched up to the timestamped date in the databse. I'm not sure exactly how to do this, since I am a Visual Composer newbie.

If anybody has any ideas I would love to hear them! Thanks in advance.