How to change Date Settings in the Server

reyboy · July 12th, 2004, 01:03 AM

Select dbo.Fin_tblTransJournalVoucher.JVdate,DATEDIFF(Day , dbo.Fin_tblTransJournalVoucher.JVdate, CONVERT(DATETIME,
'2004-02-15 00:00:00', 102)) AS Days from dbo.Fin_tblTransJournalVoucher

This Query Used to Give me (2004-01-03|43), Just Yesteray it become
(2004-03-01|-15)

What Happened? How Do I Revert the Settings?

Proud To Be Pinoy

happygv · July 12th, 2004, 08:38 AM

What format does JVdate show off? Why not use the same format for both the dates within datediff?

Code:

Select dbo.Fin_tblTransJournalVoucher.JVdate, 
    DATEDIFF(Day, CONVERT(datetime,dbo.Fin_tblTransJournalVoucher.JVdate,102), 
    CONVERT(DATETIME,'2004-02-15 00:00:00', 102)) AS Days 
from dbo.Fin_tblTransJournalVoucher

Also check what format is set as default for your sql server.

Cheers!
_________________________
- Vijay G
Strive for Perfection

reyboy · July 12th, 2004, 08:16 PM

Before it shows me this values "2004-01-03" now its "2004-03-01". If I will change the it in datediff it will have have to reprogram a lot of things.

I am more interested in knowing and changing what is the default of my sql server. The problem is I dont know how to do it. Can you teach me?

Proud To Be Pinoy

blueFrench · July 13th, 2004, 01:57 AM

I believe sql server gets its settings from the regional settings set on your computer. So you should change that from regional options.

happygv · July 13th, 2004, 07:08 AM

Yes, you can get that set in you regional settings. Someone might have changed that, which effects your current date format.

What Language is set to DEFAULT in your SQL server? Is that set to the one you wanted? I believe changing that might affect date format too.

Either by changing the regional settings options / set default to desired Language and reboot the server. This could effect the date format. May be if that doesn't sometimes change the values in registry, then you can manually change the needed values in the registry under hkey_users\.DEFAULT\control panel\international

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

reyboy · July 13th, 2004, 07:49 PM

Thank you very for the tip, just saved me from reformatting my computer. :D

Proud To Be Pinoy