Hi! I'm getting an overflow error for the MYDATE variable in this instruction:

INSERT INTO TEMP (CLIENTID,MYDATE,FLAG) VALUES (:MYCLIENT,:MYDATE,1);


the debugger shows that it tries to insert doing this:
INSERT INTO TEMP (CLIENTID,MYDATE,FLAG) VALUES (1,CAST ('01/13/2007' AS DATE),1);
but the debugger also shows MYDATE variable as 13/01/2007, why does it reverse the day and the month to insert?
MYDATE type is DATE
I'm in IB 7.5





---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]