Re: Date formats

[Rory Hewitt <roryhewitt@xxxxxxxxx>]

Does any culture use the Julian format natively (outside of the 'geek
culture', that is)?

On Tue, Dec 15, 2009 at 11:29 AM, Raul A. Jager W. <raul@xxxxxxxxxx> wrote:

> In Paraguay, as in most of the civilized world, we use ddmmyyyy
> separarted either by /, -, or .
> Is is not practical for sorting, but using "date" fields the order comes
> out Ok.
>
> But, as any other rule, there are exceptions, and now I have a task for
> which I need to sort using mmddyyyy, to list aniversarys.  For each
> month: the list of days, and for each day the list ordered by year.
>
> Bryce Martin wrote:
>
> > Date sorting is most 'natural' when done yyyymmdd.  That is why people
> > always want to switch the order of the parts.  This is actually quite mute
> > in anything that is done with native date values, but most databases on
> > the i are not set up this way.  From what I've seem most date records are
> > stored as numeric, and I'm guessing 8,0 numeric at that.  If everything
> > was stored as Date then there would be little use for all this switching
> > around since I'm not aware of too many people who display dates as
> > 2009/12/16, or 2009, Dec 16.
> >
> >
> > I wonder... if native date support had been in place since the beginning,
> > would we have ever seen the 10000.01 trick?  I'm only coming up on my 3rd
> > anniversary on the platform, so this might be a naive point of view.
> >
> >
> > Thanks
> > Bryce Martin
> > Programmer/Analyst I
> > 570-546-4777