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
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
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,
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
Apparently you didn't get the memo. Voltar blew us off. He's on vacation
in Circinus http://en.wikipedia.org/wiki/Circinus_Galaxy
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 13
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
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
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
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 that SQL
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
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
On Fri, Jan 13, 2012 at 1:29 AM, Bob Sneidar b...@twft.com 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
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
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 b...@twft.com 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
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
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
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
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
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
19 matches
Mail list logo
