U++ framework: U++ SQL » sqlite and dropdate / editdate etc

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 :: Polls :: Message Navigator
E-mail to friend

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

Fri, 25 September 2020 08:30

jimlef
Messages: 90
Registered: September 2020
Location: US

Member

Thanks for that Mirek, I was just looking into the option because my original code used datetime.ticks values. I have converted those huge numbers to epoch based ints, but I suppose it would be just as easy for me to convert that to actual sqlite dates... In fact I think I'm going to go that route Smile

Jim
Edit: Looking more closely, it seems that sqlite doesn't have an official date type, but can store dates as strings or numbers ... I can convert them to strings however, and formatting will not be difficult.

[Updated on: Fri, 25 September 2020 08:54]

Report message to a moderator

[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) ] [

] [

]

Current Time: Tue Jul 14 00:34:38 GMT+2 2026

Total time taken to generate the page: 0.00576 seconds