American date problem

Hi there,
I have just installed my MS SQL Server 2000 Box on a Windows 2003 server. I
have this database that came shipped with from my print management suppliers
that allow me track all printing activity. however one of the tables has a
field of a field type "datetime" which is recording all transaction dates in
american format. I have check my regional setting on the Windows 2003 box but
all is set to "Irish format". How can get my SQL box record dates in UK/Irish
date format rather than American format. Is there a setting that I'm missing.
Many thanks,
Liam
Datetime values are stored in a format that is independent of
language/regional settings. The client application is responsible for
formatting.
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>
|||Dates are not stored in any format -- they are stored as two numeric values.
So what you are seeing is how the client tool is showing the dates to you.
http://www.aspfaq.com/
(Reverse address to reply.)
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>