I have some defaults that use get date but for some reason now getdate and even my datetime fields won't show the seconds. I use datetime and part of many primary keys and now because my date fields can't get the seconds it is causing problems. Also now when I do a DTS from anywhere into SQL it defaults my datetime fields to shortdate and I have to go through and change them to datetime. Nothing has really changed on my servers and I have no idea why they are breaking now. I have checked the regional settings and all is well. I'm at a loss, has anyone ran into this or has any ideas? I really appreicate the help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't use seconds on date fields and get date
- Thread starter KV
- Start date
Similar threads
- Locked
- Question
