MS SQL Server ODBC - problem trying to save a date field

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

problem trying to save a date field

Felix Quevedo C.

2005-11-15, 11:23 am

Hi there, right now i'm working with a VB6 project that connects to a
SQLSERVER 2000 using a System DSN.

I discovered a problem that, i hope you can help me.

The problem is that, when i try to save a record with a date field - the
date saved in database is 2 days more that the typed date. ALWAYS 2 DAYS!!!

Don't know why.

In order to save a record to DB i try to use val = cdec(val), where val is a
date value, and for strings values i just use val = "'" & val & "'", and so
on... for diferent types of fields.

Because i'm developing for a spanish environment i decided to convert dates
in the right format ("dd/mm/yyyy") and try to have regional settings that
match national language and location.

If anybody can help me, please i will appreciate it.

Felix.

Sponsored Links