search

govert / SQLiteForExcel

A lightweight wrapper to give access to the SQLite3 library from VBA.
MIT License
256 stars 81 forks source link

Timestamp support #3

Closed amanfrinati closed 5 years ago

amanfrinati commented 7 years ago

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!

govert commented 7 years ago

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/govert/SQLiteForExcel/issues/3, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAZTwyGdui51J8J0BVnAURmY4HECSZuLks5qsPohgaJpZM4KCly7.

amanfrinati commented 7 years ago

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?

govert commented 7 years ago

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/govert/SQLiteForExcel/issues/3#issuecomment-248567719, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAZTw--3JNqXKshq0VkFKjbNmqKR2EwRks5qsQHCgaJpZM4KCly7.