U++ forum: Welcome to the forum

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

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

Sat, 26 September 2020 18:16

jimlef
Messages: 90
Registered: September 2020
Location: US

Member

I do that a lot Mirek Laughing

I am testing things out, I added a field TESTING to my products table. I added a Testing editdate to the layout for editing prodcuts.
When I save a testing date to my database, it's stored as yyyy-mm-dd, while my region is supposed to put year last. I'd like to use my region to manage the format, as that would make the code more generally usable (for later sharing). When I reload the info into my editdate field, the field is colored light red... doesn't that indicate invalid value?

index.php?t=getfile&id=6225&private=0

Attachment: example.png
(Size: 197.03KB, Downloaded 570 times)

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: Sat May 10 21:35:59 CEST 2025

Total time taken to generate the page: 0.03131 seconds