DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > The Corner Pub

Reply
 
Thread Tools Display Modes
Old 08-23-2006, 02:04 AM   #1
Richard Waller
Member
 
Richard Waller's Avatar
 
Join Date: Aug 2005
Location: Goring-by-Sea, West Sussex UK
Posts: 732
Default Getting a good date

In the UK we show abreviated dates as DDMMYY. In the US it is MMDDYY. What we really need is YYMMDD so that the directory index is in a useful order. How can we get everyone to change? Or are we happy being confused.

   
__________________
Richard Waller
www.waller.co.uk
www.goring-by-sea.uk.com
Richard Waller is offline   Reply With Quote
Old 08-23-2006, 02:17 AM   #2
PeterArnel
Member
 
Join Date: Jan 2005
Location: North of Swindon in the UK on the edge of the Cotswolds
Posts: 997
Default

Quote:
Originally Posted by Richard Waller View Post
In the UK we show abreviated dates as DDMMYY. In the US it is MMDDYY. What we really need is YYMMDD so that the directory index is in a useful order. How can we get everyone to change? Or are we happy being confused.
Richard - I thought date fields in a database coped with different formats and sorted accordingly - it would only have aproblem if the date field was set up to a number or text field in error
Peter
PeterArnel is offline   Reply With Quote
Old 08-23-2006, 03:14 AM   #3
Richard Waller
Member
 
Richard Waller's Avatar
 
Join Date: Aug 2005
Location: Goring-by-Sea, West Sussex UK
Posts: 732
Default

Peter - database software must be cleverer than I gave it credit for. But when I write letters I name the files with the person name and the date. Like peter060822. Otherwise it gets all muddled.

   
__________________
Richard Waller
www.waller.co.uk
www.goring-by-sea.uk.com
Richard Waller is offline   Reply With Quote
Old 08-23-2006, 04:58 AM   #4
iamback
Member
 
iamback's Avatar
 
Join Date: Oct 2005
Location: Amsterdam, NL
Posts: 4,894
Default

Quote:
Originally Posted by PeterArnel View Post
Richard - I thought date fields in a database coped with different formats and sorted accordingly - it would only have aproblem if the date field was set up to a number or text field in error
Peter
MySQL has indeed a DATE column type (as well as various time and timestamp formats); the representation is (what else?) ISO format. For a date that is YYYY-MM-DD; sorting will thus be always correct and you can of course use programming to format without, or with other separators (I don't, since I've been using ISO format since 1971).

The only worry is of course capturing and interpreting the data before it is stored into the database.

Many countries by now actually have the ISO standard as a national standard; that includes many European countries (like Germany) as well as for instance China.

   
__________________
Marjolein Katsma
Look through my eyes on Cultural Surfaces (soon!), My ArtFlakes shop and Flickr.
Occasionally I am also connecting online dots... and sometimes you can follow me on Marjolein's Travel Blog
iamback is offline   Reply With Quote
Old 08-23-2006, 05:15 AM   #5
Richard Waller
Member
 
Richard Waller's Avatar
 
Join Date: Aug 2005
Location: Goring-by-Sea, West Sussex UK
Posts: 732
Default

YYY-MM-DD is ISO format. Excellent. In the UK we do not have a government who will insist on what is sensible. They are too busy on Human Rights.

A big regret is that Margaret Thatcher lost her nerve when going decimal and we have half the UK on fahrenheit, kilometres and litres, and the rest on centigrade, miles and gallons. And please don't tell the conversions, it is so boring.

   
__________________
Richard Waller
www.waller.co.uk
www.goring-by-sea.uk.com
Richard Waller is offline   Reply With Quote
Old 08-23-2006, 07:25 AM   #6
ElyseC
Sysop Emeritus
 
ElyseC's Avatar
 
Join Date: Oct 2004
Location: southeastern Iowa, in the technology corridor
Posts: 2,190
Default

Quote:
Originally Posted by Richard Waller View Post
In the UK we show abreviated dates as DDMMYY. In the US it is MMDDYY. What we really need is YYMMDD so that the directory index is in a useful order. How can we get everyone to change? Or are we happy being confused.
I try to explain to people here (in the States) about sort order and why I always use YYMMDD in file names, but they think I'm just being a fussbudget and persist in using MMDDYY and, oddly, in a couple of cases DDMMYY.

Keeps me busy renaming files they send me, so I can have my nice, neat sort order.

   
__________________
Elyse
ElyseC is offline   Reply With Quote
Old 08-23-2006, 08:13 AM   #7
Michael Rowley
Member
 
Join Date: Jan 2005
Location: Ipswich (the one in England)
Posts: 5,105
Default

Marjolein:

Quote:
Many countries by now actually have the ISO standard as a national standard; that includes many European countries (like Germany) as well as for instance China
You are citing the all-numeric ISO form (YYMMDD or YYYYMMDD); the standard is, I think, only for that form. But there is no objection to the use of forms such as August 23 2006 (English traditional and American), 23 August 2006 (more recent English), or 23 Aug 06 (the NATO form). The only thing that's objectionable are references in British papers to '9/11' when they mean September 11.

   
__________________
Michael
Michael Rowley is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date handling query in SQL BinkyM Web Site Building & Maintenance 6 07-03-2007 12:59 AM


All times are GMT -8. The time now is 09:16 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.