datetime problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

datetime problem

Author

Topic

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-08-17 : 09:56:27

From one machine when select the datetime column , it showing
as '07/12/2005 04:03:03 AM'
when i select the same date from another machine the AM/Pm is not showing, IS there any setting i can turn off this Am/Pm

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-17 : 10:03:16

I believe you want to look at the regional settings in the computers control panel

====================================================
Regards,
Sean Roussy

Thank you, drive through

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-08-17 : 10:14:23

It's same on both machines

Xerxes
Aged Yak Warrior

666 Posts

Posted - 2005-08-17 : 10:17:04

I believe that the regional settings in the control panel on your Windows determines this. You said they're the same on both machines. Are you sure? What ops syses are on each?

Semper fi,
XERXES, USMC(Ret.)
------------------------------------------------------
The Marine Corps taught me everything but SQL!

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-17 : 10:18:57

double check the TIME tab. There is a difference between HH and hh.

====================================================
Regards,
Sean Roussy

Thank you, drive through

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-08-17 : 10:28:22

I checked the Regional and language options under Control Panel,
Its showing time as 10:25:20 AM, on both machines

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-08-17 : 12:12:13

where did u find the TIME tab

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-17 : 12:15:30

I believe someone already inquired as to what operating system you are using. This may help answer your last question.

====================================================
Regards,
Sean Roussy

Thank you, drive through

cbeganesh
Posting Yak Master

105 Posts

Posted - 2005-08-17 : 12:29:37

we have windows XP

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-17 : 13:32:35

As a server? OK.

Go to Start--> Settings --> Control Panel --> Regional and Language Options --> Customize Button on Regional Options Tab --> Time

====================================================
Regards,
Sean Roussy

Thank you, drive through

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources