RE: sql server, date and time

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)

“Ross” == Ross D. [email protected] 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. <[email protected]>
	 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

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.
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.

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.
And I can add Lithuania to that list too.

Regards,
Rimantas

http://rimantas.com/