I have a simple table for testing defined as follows
/****** Object: Table [dbo].[Table_1] Script Date: 6/13/2019 3:43:28 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
[datecol] [date] NULL,
[column_1] [nchar](10) NULL,
[moneyCol] [money] NULL
) ON [PRIMARY]
GO
Can connect insert & query data
But one column comes out really strange using ADO on Windows 10 (doesnt matter if I use 32 bit or 64 bit here as I get odd values either way)
Case ADODB.DataType.adDBDate // 133 A date value (yyyymmdd).
Dim v As String = mOLEObject.Value
Dim vi64 As Int64 = mOLEObject.Value
Return v
the string has “3.46420801e+9” and the int64 has 3464208001
I’m actually expecting something more like 2013-10-10 which I can see in MS SQL Server Management Studio
Any ideas on what I’m doing wrong ?