govert/SQLiteForExcel

Timestamp support

Closed this issue · 3 comments

Hi,
i'm working with your .bas with excel. After lots of tries i found that you have not insert a stdcall for bind timestamp, because your stdcall for bind date converts date value in double.
There is a way to solve this issue?
Thank you!

Hi Alberto,

What exactly do you mean by a Timestamp?
Do you mean a Date value that only has a time portion, or some sequential counter?

Internally, SQLite has no date or time storage format.
Am I missing some SQLite function – maybe you can point me to the right documentation.

-Govert

From: Alberto Manfrinati [mailto:notifications@github.com]
Sent: 21 September 2016 11:34
To: govert/SQLiteForExcel SQLiteForExcel@noreply.github.com
Subject: [govert/SQLiteForExcel] Timestamp support (#3)

Hi,
i'm working with your .bas with excel. After lots of tries i found that you have not insert a stdcall for bind timestamp, because your stdcall for bind date converts date value in double.
There is a way to solve this issue?
Thank you!


You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHubhttps://github.com//issues/3, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAZTwyGdui51J8J0BVnAURmY4HECSZuLks5qsPohgaJpZM4KCly7.

Hi Govert,

with timestamp i mean a date value like "2016/09/21 11:52".
In your Sqlite3Demo, when you call SQLite3BindDate, date bind works because your date data type (on the table created in Sub TestBinding) is REAL. In my case however I am working with a table with date data type timestamp.
Maybe I must not use SQLite3BindDate to bind my date value?

It would depend on how you store the date in the database.

The SQLite3BindDate assumes it is storing the Julian day format (as described here: https://www.sqlite.org/lang_datefunc.html)

If you’re storing as text or a number with different offset, you need to read it back using the appropriate type.

From: Alberto Manfrinati [mailto:notifications@github.com]
Sent: 21 September 2016 12:07
To: govert/SQLiteForExcel SQLiteForExcel@noreply.github.com
Cc: Govert van Drimmelen govert@icon.co.za; Comment comment@noreply.github.com
Subject: Re: [govert/SQLiteForExcel] Timestamp support (#3)

Hi Govert,

with timestamp i mean a date value like "2016/09/21 11:52".
In your Sqlite3Demo, when you call SQLite3BindDate, date bind works because your date data type (on the table created in Sub TestBinding) is REAL. In my case however I am working with a table with date data type timestamp.
Maybe I must not use SQLite3BindDate to bind my date value?


You are receiving this because you commented.
Reply to this email directly, view it on GitHubhttps://github.com//issues/3#issuecomment-248567719, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAZTw--3JNqXKshq0VkFKjbNmqKR2EwRks5qsQHCgaJpZM4KCly7.