Rampftl
Posts: 3
|
| Posted: 05/11/2007, 10:03 AM |
|
I have a form with date controls in it.
When adding a new record my database always does an insert with wrong date formate. Independently from what I set in Format property, Default DateFormat etc. it uses the format
'05/11/2007 00:00:00'
in the insert string.
MySql accepts the insert but fills the date field with '0000-00-00 00:00:00'.
When doing an insert manually with a date format '2007-05-11 00:00:00' the date field is filled correctly.
So how can I manipulate the date format CCS is using to do inserts and updates?
kind regards
Rampftl
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 05/11/2007, 10:47 AM |
|
Use the search in the top menu of this forum.
Search for date format, it is described many many times already even today/yesterday it was answered
your date setting in project settings are wrong or incomplete.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
