Skip to main content

SQLite and Dates

Sometimes we want to store the date/time as an integer. It makes sense sometimes. If you want to run updates on everything higher than a certain number, you can do it quite easily with an integer. If you want to run everything all over again, compare it to zero. All records will be processed again. Easy peasy. Here’s how one of my tables looks to achieve this integer method for a date/time: CREATE TABLE notes( id INTEGER primary key, title TEXT, note_txt TEXT, created_dt INTEGER not null default (strftime('%s', 'now', 'localtime')), exported_flag INTEGER not null default 0 ); See how that works? Yeah, it’s pretty neat if I do say so myself. Of course you have to convert it to make it human readable. To do that, I usually do something like this: SELECT id, title, note_txt, created_dt, strftime('%Y-%m-%d %H:%M', created_dt) as formatted_dt FROM notes ORDER BY id DESC LIMIT 1 But, I can see what you’re thinking. Why do it...
Post a Comment

Article of Faith 2

We believe that men will be punished for their own sins, and not for Adam’s transgression.

The second Article of Faith clearly states that we don’t believe in original sin. Original sin, is the sin which Adam and Eve committed in the Garden of Eden. That is, hearkening unto Satan and eating of the fruit. In turn, we are only responsible for the sins which we commit here in our own lives. Seems nice for sure, don’t have to be held to another person’s sins to dictate our lives.

Well...that’s not the whole truth though.

You see, in November of 2015 The Church of Jesus Christ of Latter-day Saints included some things in their Official Handbook of Instructions (Handbook One) redefining apostasy. It included in that definition that members in homosexual relationships would be declared in apostasy. (It’s okay to have the thoughts, just don’t act on them.)

It also changed a few things around for children of those same sex couples. Children who have two parents who are the same sex, cannot be baptized at the age of eight. Thus they are being punished for the “sins” of their parents...which appears to go against the 2nd Article of Faith.

Adam is our first parent, those to whom we are direct descents of are our biological parents. Either way, we shouldn’t be judged for either of their sins. Like the story of the blind man in the New Testament of the Bible. The Savior’s disciples asked who had sinned the man or his parents that he had been born blind. The Savior’s response was that neither had sinned. It wasn’t his or his parents fault that he was born blind.

Should not this be the case with children who are born to same sex couples? People should be allowed to love each other no matter their gender. Didn’t God teach love? Didn’t Jesus teach that we should love everyone no matter what?
Labels:

Comments

Post a Comment

Popular posts from this blog

Didn't Sleep

 What's the point of sleep anymore if I can't sleep? I don't think I slept any good last night. I was awake at 3 am wondering to myself, what on earth am I doing awake? Yeah, that happened. It doesn't make any sense. Fortunately, it's the weekend. So, I can catch up on sleep tonight. I don't have to be anywhere tomorrow, so it's a good opportunity to actually sleep for once. Whatever the case, I hope I'll be able to fall asleep and stay asleep. We will see what happens.
Post a Comment
Read more

Temptation Bible vs Book of Mormon

In the Bible in 1 Corinthians 10:13 we find: There hath no temptation taken you but such as is common to man: but God is faithful, who will not suffer you to be tempted above that ye are able ; but will with the temptation also make a way to escape, that ye may be able to bear it. But what might seem as a contradiction is found in Alma 13:28 But that ye would humble yourselves before the Lord, and call on his holy name, and watch and pray continually, that ye may not be tempted above that which ye can bear , and thus be led by the Holy Spirit, becoming humble, meek, submissive, patient, full of love and all long-suffering; So, which is it? Either God tempts you to a point and stops, or you have to actively pray not to be tempted beyond that no return point. Which is it?
Post a Comment
Read more

An Opposition In All Things

Long has been the story told about how there must be an opposition in all things. From the pre-existence there was Satan, Lucifer the Son of the Morning. In the beginning we were with God in his presence. We learned all we could while there. Until the moment we couldn’t progress any more, we were unable to become like God. So, we were given the opportunity to come to Earth to gain a body. A Savior would be provided to atone for our sins enabling us to come back to the presence of God. The idea that an opposition must be in all things comes from 2nd Nephi: For it must needs be, that there is an opposition in all things. If not so, my firstborn in the wilderness, righteousness could not be brought to pass, neither wickedness, neither holiness nor misery, neither good nor bad. Wherefore, all things must needs be a compound in one; wherefore, if it should be one body it must needs remain as dead, having no life neither death, nor corruption nor incorruption, happiness nor misery, neither...
Post a Comment
Read more