Re: SQL Date Formatting

On Sat, Jan 14, 2012 at 1:07 AM, Ken Ray wrote: > > Just a little 'gotcha' here - I've been doing A LOT with dates and times > recently, and discovered that you either need to make sure the > 'useSystemDate' is set to true in your code, OR make sure to add the > "system" keyword in any format con

Re: SQL Date Formatting

Jerry- Friday, January 13, 2012, 1:04:21 PM, you wrote: > Assuming AMPAR and OHMAR multiply successfully. -- -Mark Wieder mwie...@ahsoftware.net ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsub

Re: SQL Date Formatting

So, could you then say that an analog metric clock had too much time on it's hands? Bob On Jan 13, 2012, at 12:26 PM, Ken Ray wrote: > I'm just waiting for everyone to adopt the Metric Calendar: > > 100 seconds per minute > 100 minutes per hour > 10 hours per day > 10 days per week > 10 weeks

Re: SQL Date Formatting

Great Scott! I used to think an hour of English class was a long time before! 3600 seconds vs 1. Yikes. Our kids would hate us. -Ken On 13/01/2012 20:26, Ken Ray wrote: I'm just waiting for everyone to adopt the Metric Calendar: 100 seconds per minute 100 minutes per hour 10 hours per

Re: SQL Date Formatting

On 1/13/12 2:26 PM, Ken Ray wrote: I'm just waiting for everyone to adopt the Metric Calendar: 100 seconds per minute 100 minutes per hour 10 hours per day 10 days per week 10 weeks per month 10 months per year Yes! More hours in a day! Been asking for that for years. -- Jacqueline Landman G

Re: SQL Date Formatting

Apparently you didn't get the memo. Voltar blew us off. He's on vacation in Circinus We're on our own. Scott Rossi Creative Director Tactile Media, UX Design Recently, stephen barncard wrote: > VOLTAR WILL SAVE US - IGNORE ALIEN ORDERS > > On

Re: SQL Date Formatting

Assuming AMPAR and OHMAR multiply successfully. On Jan 13, 2012, at 12:55 PM, stephen barncard wrote: > VOLTAR WILL SAVE US - IGNORE ALIEN ORDERS > > On 13 January 2012 12:44, Scott Rossi wrote: > >> None of this matters. >> >> http://www.greatdreams.com/end-world.htm >> >> :-) >> >> Regard

Re: SQL Date Formatting

VOLTAR WILL SAVE US - IGNORE ALIEN ORDERS On 13 January 2012 12:44, Scott Rossi wrote: > None of this matters. > > http://www.greatdreams.com/end-world.htm > > :-) > > Regards, > > Scott Rossi > Creative Director > Tactile Media, UX Design > > > > Stephen Barncard San Francisco Ca. USA more abo

Re: SQL Date Formatting

I remember a calendar we had at work - two Saturdays, two Sundays (cause everyone loves weekends), no Mondays (cause everyone hates them), no Firdays (cause projects are always due on Fridays), Tuesday, Wednesday, Thursday were still there. Pete On Fri, Jan 13, 2012 at 12:26 PM, Ken Ray wrote: >

Re: SQL Date Formatting

None of this matters. http://www.greatdreams.com/end-world.htm :-) Regards, Scott Rossi Creative Director Tactile Media, UX Design Recently, Jerry Jensen wrote: > In the all-28 day months scheme, if months start on Sunday, every month would > have a Friday the 13th. > > In the metric cale

Re: SQL Date Formatting

In the all-28 day months scheme, if months start on Sunday, every month would have a Friday the 13th. In the metric calendar, how many Friday the 13ths would there be? Would there even be Fridays? This year, there are 3 Friday the 13ths - in 13 weeks! I'm a-scared… Jerry Jensen On Jan 13,

Re: SQL Date Formatting

On 2012-01-13, at 11:46 AM, Pete wrote: > Thanks Kay and Ken for some great ideas and warnings on this whole date > issue. Ken, thanks for the date conversion script you sent me a few months > back, very useful. > > I saw a headline somewhere recently that there's a move afoot to start > using

Re: SQL Date Formatting

Thanks Kay and Ken for some great ideas and warnings on this whole date issue. Ken, thanks for the date conversion script you sent me a few months back, very useful. I saw a headline somewhere recently that there's a move afoot to start using a new calendar! Apparently every month will have 28 d

Re: SQL Date Formatting

> 3) I love the fact I don't have to take into account if a user is using > mm/dd/yy format or dd-mm-yy format, once it converted to dateItems it's the > same on EVERY system. Just a little 'gotcha' here - I've been doing A LOT with dates and times recently, and discovered that you either need to

Re: SQL Date Formatting

On Fri, Jan 13, 2012 at 1:29 AM, Bob Sneidar wrote: When I need to work with the dates in Livecode, I run the dates through my > conversion functions first. It would just be nice to have an option in the > convert command. No big deal though. > > I appreciate you've already achieved a suitable so

Re: SQL Date Formatting

It's an ISO standard format designed to be unambiguous. On 01/12/2012 9:34 AM, Bob Sneidar wrote: I think (I will be corrected if I am wrong) that it is a Canadian format. -- David Glass - Gray Matter Computing graymattercomputing.com Help Desk: http://www.graymattercomputing.com/helpdesk 559-

Re: SQL Date Formatting

I think (I will be corrected if I am wrong) that it is a Canadian format. I don't think it is a mac specific problem. I went through all the date formats on the Mac OS and found that Canada is the only country listed that formats the dates this way. I also think it makes a lot more sense. Bob

Re: SQL Date Formatting

On Jan 11, 2012, at 6:53 PM, Pete wrote: > Hi Bob, > I guess it depends on what you mean by "real dates" SQL date fields are > pretty specific as to their format, that's why you give them a type of DATE > or DATETIME. It's just a case of adjusting your SELECT statement to use > the functions th

Re: SQL Date Formatting

I have to say something here. I struggled with date formats trying to make them all -MM-DD and you are trying to do something different. I think of the -mm-dd as "real" date. It is easily readable (as seconds aren't) and sorts perfectly. It is not one of the defaults for system date on the

Re: SQL Date Formatting

Hi Bob, I guess it depends on what you mean by "real dates" SQL date fields are pretty specific as to their format, that's why you give them a type of DATE or DATETIME. It's just a case of adjusting your SELECT statement to use the functions that SQL provides to return the date in whatever format

Re: SQL Date Formatting

No you are right about it being a choice of one or the other. My functions only convert dates, so they are a lot simpler than yours, and I don't do any error checking. I ended up converting all my sql columns to date type and presenting my users with the sql format date. I then use a date picker

Re: SQL Date Formatting

I could massage the sql date format in my select statement, but I am trying to keep my select statements as simple as I can, so I have 2 functions that convert to and from the standard sql date format. Bob On Jan 11, 2012, at 5:55 PM, Warren Samples wrote: > On 01/11/2012 07:20 PM, Bob Sneid

Re: SQL Date Formatting

h... I get it. have SQL change the way IT looks at dates. Well that would work. Instead though I decided to bite the bullet and write two functions to convert to and from standard mySQL date format. Thanks for the info though I will probably use that elsewhere. Bob On Jan 11, 2012, at 5:

Re: SQL Date Formatting

Did I misunderstand your requirements, Bob? On 11 January 2012 18:07, stephen barncard wrote: > Really, this is no big deal. You can either convert at the Livecode end, > or if you don't need to sort by seconds, you could just make the date field > as a plain text field. Also consider storing ti

Re: SQL Date Formatting

Really, this is no big deal. You can either convert at the Livecode end, or if you don't need to sort by seconds, you could just make the date field as a plain text field. Also consider storing time as seconds in the database, which is sortable. The second handler I found useful too. function co

Re: SQL Date Formatting

On 01/11/2012 07:20 PM, Bob Sneidar wrote: Hi all. I am having F-I-TZ working with dates in mySQL. I WANT to store the dates as real dates, but mySQL formats them as -mm-dd. Livecode does no such thing and nothing I know how to do can get Livecode to work with dates in this format AS dates

Re: SQL Date Formatting

Can't try it but I believe you can do something like select field1, field2, DATE_FORMAT(yourdatefield,"%m/%d/%Y" from On Wed, Jan 11, 2012 at 6:20 PM, Bob Sneidar wrote: > Hi all. I am having F-I-TZ working with dates in mySQL. I WANT to store > the dates as real dates, but mySQL formats t

SQL Date Formatting

Hi all. I am having F-I-TZ working with dates in mySQL. I WANT to store the dates as real dates, but mySQL formats them as -mm-dd. Livecode does no such thing and nothing I know how to do can get Livecode to work with dates in this format AS dates. It's no good for my present purposes to w