Re: problem trying to save a date field

Have a look at these:


http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp
Datetimes
http://www.murach.com/books/sqls/article.htm Datetime Searching

--
Andrew J. Kelly SQL MVP


"Felix Quevedo C." <FelixQuevedoC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:378DC5C1-A528-4E78-AF8C-EE6713C33399@xxxxxxxxxxxxxxxx
> 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.


.

Loading