# RE: sql server, date and time

**URL:** <https://www.ruby-forum.com/t/re-sql-server-date-and-time/94468>\
**Category:** Rails\
**Created:** [May 4, 2006, 7:41am UTC](https://www.ruby-forum.com/t/re-sql-server-date-and-time/94468 "2006-05-04T07:41:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ross\_D](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b19c9b/32.png) [@Ross\_D](https://www.ruby-forum.com/u/Ross_D)\
**Post date:** [May 4, 2006, 7:41am UTC](https://www.ruby-forum.com/t/re-sql-server-date-and-time/94468/1 "2006-05-04T07:41:55Z")

</div>

Better to use dates in the format of yyyy-mm-dd it’s unambiguous. I  
think there is even an ISO standard for this.

Ross (a colonial that has a date time format of dd-mm-yyyy)

---

<div class="post-metadata">

**Author:** ![Ross\_D](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b19c9b/32.png) [@Ross\_D](https://www.ruby-forum.com/u/Ross_D)\
**Post date:** [May 4, 2006, 11:02am UTC](https://www.ruby-forum.com/t/re-sql-server-date-and-time/94468/2 "2006-05-04T11:02:12Z")

</div>

> > > > > “Ross” == Ross D. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) writes:

> Better to use dates in the format of yyyy-mm-dd it’s unambiguous. I  
> think there is even an ISO standard for this.

## Yes, ISO 8601. I think Sweden is the only country in the world where it’s in common use.

```
	     Calle D. <removed_email_address@domain.invalid>
	 http://www.livejournal.com/users/cdybedahl/
"I don't know what art these programs are state-of; possibly 

```

macrame."  
– Dr Richard A. O’Keefe, comp.risks

---

<div class="post-metadata">

**Author:** ![Ross\_D](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b19c9b/32.png) [@Ross\_D](https://www.ruby-forum.com/u/Ross_D)\
**Post date:** [May 5, 2006, 2:08pm UTC](https://www.ruby-forum.com/t/re-sql-server-date-and-time/94468/3 "2006-05-05T14:08:17Z")

</div>

Rimantas L. wrote:

> > > Better to use dates in the format of yyyy-mm-dd it’s unambiguous. I  
> > > think there is even an ISO standard for this.
> > 
> > Yes, ISO 8601. I think Sweden is the only country in the world where  
> > it’s in common use.
> 
> Far from it: [Implementation of the ISO 8601 Standard Around The World.](http://www.qsl.net/g1smd/isoimp.htm)  
> And I can add Lithuania to that list too.

Not sure what that’s a list of. It has Denmark on there, and I don’t  
think I’ve ever seen the yyyy-mm-dd format in use here, so it’s probably  
not a list of countries where it’s actually in common use.

---

<div class="post-metadata">

**Author:** ![Ross\_D](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/b19c9b/32.png) [@Ross\_D](https://www.ruby-forum.com/u/Ross_D)\
**Post date:** [May 4, 2006, 11:35am UTC](https://www.ruby-forum.com/t/re-sql-server-date-and-time/94468/4 "2006-05-04T11:35:47Z")

</div>

> > Better to use dates in the format of yyyy-mm-dd it’s unambiguous. I  
> > think there is even an ISO standard for this.
> 
> Yes, ISO 8601. I think Sweden is the only country in the world where  
> it’s in common use.

Far from it: [Implementation of the ISO 8601 Standard Around The World.](http://www.qsl.net/g1smd/isoimp.htm)  
And I can add Lithuania to that list too.

## Regards, Rimantas

[http://rimantas.com/](http://rimantas.com/)