U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » sqlite and dropdate / editdate etc (Can you receive an integer value and display as date?)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: sqlite and dropdate / editdate etc [message #54895 is a reply to message #54888]

Sat, 26 September 2020 04:28

mr_ped is currently offline

mr_ped
Messages: 826
Registered: November 2005
Location: Czech Republic - Praha

Experienced Contributor

just a general note: I would rather store epoch seconds or some UTC timestamp than formatted date.
The particular formatting/timezone should be done when viewing the data and adjusted to current user locale/preference/options, but database should have the data itself. (that way if multiple users from different timezones are viewing the same datetime, each user sees their own familiar form of it)

Also with storing the formatted date (in general sense, if you store any kind of date) you may easily run into some peculiarities of certain dates and times (for example there's every now and then a day with 61 seconds in last minute, i.e. 23:59:60, etc), so having it in form of some timestamp supported by some common datetime library (or C++ native support, I think there's some date/time stuff added recently in C++17 or C++20? or was it already C++14?) is usually the safest way, how to avoid all of these complex things around time, and just use the library functions.

Report message to a moderator

Send a private message to this user

[Message index]

		sqlite and dropdate / editdate etc By: jimlef on Fri, 25 September 2020 07:19
		Re: sqlite and dropdate / editdate etc By: mirek on Fri, 25 September 2020 08:18
		Re: sqlite and dropdate / editdate etc By: jimlef on Fri, 25 September 2020 08:30
		Re: sqlite and dropdate / editdate etc By: mirek on Sat, 26 September 2020 15:10
		Re: sqlite and dropdate / editdate etc By: jimlef on Sat, 26 September 2020 18:16
		Re: sqlite and dropdate / editdate etc By: mirek on Mon, 28 September 2020 14:19
		Re: sqlite and dropdate / editdate etc By: jimlef on Mon, 28 September 2020 15:59
		Re: sqlite and dropdate / editdate etc By: jimlef on Fri, 25 September 2020 23:37
		Re: sqlite and dropdate / editdate etc By: mr_ped on Sat, 26 September 2020 04:28
		Re: sqlite and dropdate / editdate etc By: jimlef on Sat, 26 September 2020 07:43
		Re: sqlite and dropdate / editdate etc By: jimlef on Mon, 28 September 2020 17:41
		Re: sqlite and dropdate / editdate etc By: mirek on Mon, 28 September 2020 17:49
		Re: sqlite and dropdate / editdate etc By: mirek on Mon, 28 September 2020 18:06
		Re: sqlite and dropdate / editdate etc By: jimlef on Mon, 28 September 2020 18:51
		Re: sqlite and dropdate / editdate etc By: jimlef on Mon, 28 September 2020 20:33
		Re: sqlite and dropdate / editdate etc By: mirek on Mon, 28 September 2020 22:51
		Re: sqlite and dropdate / editdate etc By: jimlef on Tue, 29 September 2020 00:51

Previous Topic:	How does All_Tables determine if a table exists?
Next Topic:	Program changing column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat May 10 19:20:38 CEST 2025

Total time taken to generate the page: 0.01205 seconds