Last reply... I figured out the cause. I had a Regex to validate but there was
a second validation I forgot about with a DateTime object check causing the
issue - so blank was defaulting. I removed it and no issue.
Thanks!
Scott ValleryEcclesiastes 4:9-10
On Tuesday, February 5, 2019, 12:05
On 5 Feb 2019, at 4:58pm, Shawn Wagner wrote:
> Reread the rules at the start of 3.1. TIME doesn't have any of the
> substrings used to indicate a particular other affinity, so it's treated as
> NUMERIC.
You're right. I somehow remembered the default as TEXT, not NUMERIC. I was
wrong. Thank
Hi Simon...
Thanks, I do have my moments! LOL! I have a Regex on the GUI limiting the user
to hh:mm:ss format or simply blank. Somehow that must be getting translated
into a full date and time as default when blank.
Scott ValleryEcclesiastes 4:9-10
On Tuesday, February 5, 2019, 11:55:47 AM
Reread the rules at the start of 3.1. TIME doesn't have any of the
substrings used to indicate a particular other affinity, so it's treated as
NUMERIC.
On Tue, Feb 5, 2019, 8:53 AM Simon Slavin On 5 Feb 2019, at 4:11pm, David Raymond wrote:
>
> > "Time(8)" ends up as numeric affinity for that f
On 5 Feb 2019, at 4:45pm, Scott wrote:
> I think I understand now and I'm using SQLite Studio. It appears SQLite
> Studio is acting as a enhanced wrapper around SQLite3.
That makes a lot more sense. Well done for figuring it out.
You have lots of options on how to store your dates. You can
On 5 Feb 2019, at 4:11pm, David Raymond wrote:
> "Time(8)" ends up as numeric affinity for that field.
The table in 3.1.1 shows how SQLite recognises the type you supply and turns it
into a type it can use. The lowest row of the table shows that "DATETIME" is
recognised as NUMERIC. However,
t: Re: [sqlite] My TimeStamp field keeps populating though I don't write
anything to it
On 5 Feb 2019, at 3:29pm, Scott wrote:
> Thanks for the timely response. I provided below the details. "Time(8)" is
> the generated description of the structure defined by SQLite3 based up
I think I understand now and I'm using SQLite Studio. It appears SQLite Studio
is acting as a enhanced wrapper around SQLite3. I did some reading and there
is a SQLite Studio manual with with a list of 16 data types and it looks as if
you can configure editors around those data types. I proba
number, and thus it leaves it alone
and stores it as-given as text.
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Tuesday, February 05, 2019 10:44 AM
To: SQLite mailing list
Subject: Re: [sqlite] My TimeStamp f
On 5 Feb 2019, at 3:29pm, Scott wrote:
> Thanks for the timely response. I provided below the details. "Time(8)" is
> the generated description of the structure defined by SQLite3 based upon Data
> Type options. So I apologize if I don't understand you comment.
SQLite didn't generate "Time(3)"
Hi Tim!
"Time(8) has no meaning to SQLite"
Thanks for the timely response. I provided below the details. "Time(8)" is the
generated description of the structure defined by SQLite3 based upon Data Type
options. So I apologize if I don't understand you comment.
Thanks!
Column Data Type Size---
On 05 Feb 2019, at 13:08, Scott wrote:
> I have a Comment table with the fields: CommentID, Summary, Comment, Pages,
> TimeStamp, Hyperlink. The TimeStamp field is setup as a Time(8), time with 8
> characters only. Not every comment in this table requires a timestamp, so it
> should remain null.
I have a Comment table with the fields: CommentID, Summary, Comment, Pages,
TimeStamp, Hyperlink. The TimeStamp field is setup as a Time(8), time with 8
characters only. Not every comment in this table requires a timestamp, so it
should remain null. However, it has started adding "Thu Jan 01 00:
13 matches
Mail list logo