> Does anyone know if the date function returns false if it cannot convert
> specified date/time to the format?  If not, does anyone have a rule set
> use to verify the date is a valid convertible date?  I need to update a
> in MSSQL, and it will fail if the date is incorrect.  I've validated for
> basic things, but just am not sure what the best way would be to validate
> the actual date itself.  I was thinking of RegExp, but not certain if that
> would really work for multiple date formats for example:
> March 15, 2002
> 03/15/2002
> 3/15/2002
> and so on and so forth.  The field actually requests a dd/mm/yy format,
> you know how people follow instructions.

Use "YYYYMMDD HH:MM:SS" (without "-") format date when inserts or updates
fields in MSSQL, MYSQL etc.
For example: INSERT INTO tblxxx (fielddatetime,fieldother) VALUES ('20020311
18:33:44','something else')

I use it in that way and it is the best method I think.
Mayby you may use odbc structure {ts 'yyyy-mm-dd hh:mm:ss'}
For example: INSERT INTO tblxxx (fielddatetime,fieldother) VALUES ({ts
'20020311 18:33:44'},'something else')

good luck with dates ;-)
BTW I recommend you to explore MSSQL Book Online! It has quite good and a
lot of knowledge.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to