Help Please on how to insert/retrieve dates in UK format!!

[jisque]

I am using SQL Server 2005 Express. My computer system date is in the UK format (dd/mm/yy).
Have been strugling to insert and retrieve dates in the UK format. For example with the following
example if I enter a date, I can only seem to retrieve it in the US format.


CREATE TABLE X (
theDate smalldatetime);

INSERT INTO X
VALUES(12/09/2008);

SELECT theDate
FROM X;

Is there any simple - beginner - way to do this?

Thanks.

 

[gmmastros]

thread183-1240616

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom