HEY BOB COPYCAT! On Mon, Oct 16, 2017 at 1:34 PM, Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote:
> May want to check out the MasterLibrary then. It's got a lot of great > commands and functinos, one of which will format a date any way you like, > including sql date. > > Bob S > > > > On Oct 16, 2017, at 10:14 , Andrew Bell via use-livecode < > use-livecode@lists.runrev.com> wrote: > > > >> From: Bob Sneidar <bobsnei...@iotecdigital.com> > >> To: How to use LiveCode <use-livecode@lists.runrev.com> > >> Subject: Re: is a date > >> Message-ID: <6eb529a3-5d21-4186-bd90-641746e96...@iotecdigital.com> > >> Content-Type: text/plain; charset="us-ascii" > >> > >> This probably matters to no one at all, but SQL does not store dates > with forward slashes. SQL datetime formats look like this: > >> > >> yyyy-dd-mm hh:mm:ss > >> > >> Bob S > >> > > > > It mattered to me recently on a project I was working on so I wrote > these two scripts to help me generate a LC version of the mySQL version of > "timestamp": > > > > on timeStamp > > put the internet date into tTheDate > > convert tTheDate to dateitems > > put item 1 of tTheDate into tYear > > put item 2 of tTheDate into tMonth > > put item 3 of tTheDate into tDay > > put item 4 of tTheDate into tHour > > put item 5 of tTheDate into tMinute > > put item 6 of tTheDate into tSecond > > > > leadingZero tMonth > > leadingZero tDay > > leadingZero tHour > > leadingZero tMinute > > leadingZero tSecond > > > > put tYear & "-" & tMonth & "-" & tDay && tHour & ":" & tMinute & ":" & > tSecond into tTimeStamp > > return tTimeStamp > > end timeStamp > > > > on leadingZero @pDateItem > > if the length of pDateItem = 1 then > > put "0" before pDateItem > > end if > > end leadingZero > > > > > > A new date/time format of "database" would be useful for something like > this. > > > > --Andrew Bell > > > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode