PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV 2024 → datetime columns with MySQL native access
datetime columns with MySQL native access
Iniciado por Pascal Scheffers, 14,jul. 2004 12:10 - No hay respuesta
#1
Publicado el 14,julio 2004 - 12:10
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.
→ Volver a WINDEV 2024