U++ framework
Do not panic. Ask here before giving up.
Home » U++ Library support » U++ SQL » SQLite: Date and Time
SQLite: Date and Time [message #17136] Wed, 30 July 2008 18:01 Go to next message
WebChaot is currently offline  WebChaot
Messages: 53
Registered: September 2006
Location: Austria, Vienna
Member
Hi!

I'm currently working with SQLite and wanted to generate a timestamp column. I used TIME_ in schema - but got a DATE column in database.

The problem is in sqlite3schema.h:

If you change all TIME calls from "date" to "datetime" it works correct.


WebChaot

Report message to a moderator

Re: SQLite: Date and Time [message #17170 is a reply to message #17136] Fri, 01 August 2008 10:06 Go to previous message
mirek is currently offline  mirek
Messages: 14290
Registered: November 2005
Ultimate Member
Thanks, fixed. However, AFAIK, Sqlite converts both to TEXT column... (it does not support date or datetime).

Mirek

Report message to a moderator

Previous Topic: First Firebird for U++ steps
Next Topic: Connecting to multiple databases.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Sun Apr 26 15:44:06 GMT+2 2026

Total time taken to generate the page: 0.00581 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software