MySQL datetime pattern

[dsmithsonhome]

Hi. Suppose I want to specify a date range using input controls. The dates are in MySQL datetime format:

Code:

yyyy-mm-dd hh:mm:«»ss.  I've decided I will use two inputs, MaxTime and MinTime or something like that.  The two parameters will feed into a third parameter which constructs the WHERE clause for the SQL query.  Question is, how do I specify the pattern in the input control to get the datetime format that MySQL will understand?

Post edited by: dsmithsonhome, at: 2006/08/24 02:43