Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
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: 13975
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: Mon Apr 29 05:14:08 CEST 2024

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

Powered by: FUDforum 3.0.5.
Copyright ©2001-2013 FUDforum Bulletin Board Software