PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → datetime columns with MySQL native access
datetime columns with MySQL native access
Started by Pascal Scheffers, Jul., 14 2004 12:10 PM - No answer
#1
Posted on July, 14 2004 - 12:10 PM
Hi,
I've hit yet another MySQL quirk:
If I do a query with 'datetime' columns, it the datetime values seconds are dropped from the value: 2004-07-13 08:15:07 appears as 2004071308150000 in my 'Date Source' variable. Has anyone else noticed this?
I've checked - the seconds are there in the field in the database, if I use a cast(colname as char) I see the seconds in the result set. Unfortunately, using cast() only works on hquerywithoutcorrection, which doesn't transfer text fields which are part of the same query
- Pascal.
→ Go back to WINDEV 2024