is a date

Mike Kerner MikeKerner at roadrunner.com
Mon Oct 16 14:07:16 EDT 2017


HEY BOB COPYCAT!

On Mon, Oct 16, 2017 at 1:34 PM, Bob Sneidar via use-livecode <
use-livecode at 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 at lists.runrev.com> wrote:
> >
> >> From: Bob Sneidar <bobsneidar at iotecdigital.com>
> >> To: How to use LiveCode <use-livecode at lists.runrev.com>
> >> Subject: Re: is a date
> >> Message-ID: <6EB529A3-5D21-4186-BD90-641746E96734 at 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 at 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 at 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."



More information about the Use-livecode mailing list