Re: CDate() different value in VB6 and SQL 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Mike Williams" <mikea@xxxxxxxxxxxxxxxxx> wrote in message
news:O4qWFrucIHA.1168@xxxxxxxxxxxxxxxxxxxxxxx

Does anyone else experience this: CDate(34940) returns 2/15/2008 in VB 6
and the same conversion in SQL
2005 returns 2/17/2008?

Well that's weird? I didn't know there were 17 months in a year ;-)

So tell me, in England, when you speak the date, do you actually say (on a
REGULAR basis) "Today is nineteenth February, two thousand eight"?

Or "Today is the nineteenth of February, two thousand eight"?

Or do you say it like virtually everyone in America: "Today is February
nineteenth, two thousand eight"?

Because if you say it like the last one, why don't you WRITE it like the
last one? I've always wondered.

I can understand why they write it dd.mm.yyyy in Germany, for example,
because they actually DO say the day number before the month. So again, just
curious.


.

Relevant Pages

  • Re: Where are the CONVERT & CAST functions in MDB?
    ... but I cannot the SQL type-conversion functions that works in SQL Server ... Each function coerces an expression to a specific data type. ... CVar Variant Same range as Double for numerics. ... you can document your code using the data-type conversion ...
    (microsoft.public.access.modulesdaovba)
  • Re: Where are the CONVERT & CAST functions in MDB?
    ... I thought those functions were only for VBA code, not SQL. ... Each function coerces an expression to a specific data type. ... CVar Variant Same range as Double for numerics. ... you can document your code using the data-type conversion ...
    (microsoft.public.access.modulesdaovba)
  • Re: Where are the CONVERT & CAST functions in MDB?
    ... I thought those functions were only for VBA code, not SQL. ... Each function coerces an expression to a specific data type. ... CVar Variant Same range as Double for numerics. ... you can document your code using the data-type conversion ...
    (microsoft.public.access.modulesdaovba)
  • Re: Opinions on approach, please...
    ... cobol code needed to run this application in sql. ... conversion programs let me know. ...
    (comp.lang.cobol)
  • DBConvert for FoxPro & MSSQL 2.0.2
    ... DBConvert for MS FoxPro & MS SQL is a database migration tool for data ... Unicode Support, Primary keys and Indexes conversion, ...
    (comp.software.shareware.announce)