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
>

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,
LiamDatetime 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
>

AM PM format

How can I show time portion of a date in "hh:mm:ss" AM?PM format?
ThanksIn the format property for a textbox use the following:
hh:mm:ss tt
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> How can I show time portion of a date in "hh:mm:ss" AM?PM format?
> Thanks
>
>|||What Language setting have you used on the Report?
Click on the Report Property and look for Language. Set it to English
(United States)
Then click on a textbox with a time datatype in, and set T as format. Now
you have am/pm.
If you don't want to change the language of the whole report, you'll have to
use some formating function on the expression. Or change the format in your
query, to make it return the time in the correct format from your data
source.
Kaisa M. Lndahl Lervik
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:utU3$sP3GHA.3428@.TK2MSFTNGP05.phx.gbl...
> How can I show time portion of a date in "hh:mm:ss" AM?PM format?
> Thanks
>