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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
GetDate() showing seconds
- Thread starter SarahG
- Start date
timscronin
MIS
How are you selecting it?
If I do select getdate() in QA
I return 2003-01-10 09:49:39.223. Are youy calling this from an app or just in QA
If I do select getdate() in QA
I return 2003-01-10 09:49:39.223. Are youy calling this from an app or just in QA
- Thread starter
- #3
Yes I'm using QA, just straight
select getdate()
Actually in the meantime, I've found the convert function returns what I want, if I run
select convert(datetime,getdate(),108)
But I'd be interested in knowing why my QA defaults to my format and yours to another.
select getdate()
Actually in the meantime, I've found the convert function returns what I want, if I run
select convert(datetime,getdate(),108)
But I'd be interested in knowing why my QA defaults to my format and yours to another.
- Status