VB.net and MSSQL Dates

[WJProctor]

Hi there, im having such a carry on with dates. I have 2 tables, both which have a date coloumn in them. Set to datetime. When dates are inserted they seem to store in the same way. I.e. MM/DD/YYYY.

When i read the dates back, one table works fine and returns 9/1/2004 if i then ask for the month it gives me 9 and year 2004. How ever with the other table it returns 08/01/2004 and if i ask for month then it gives me 01 and year 2004. Why when im doing exactly the same in the code is the other parts not working. Am i setting something wrong in the database.

Hope someone can help me out.

Regards


James Proctor

http://www.ebmis.co.uk

 

[philhege]

Sounds like your locale settings are different on the two SQL boxes.

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....