why different ans. get in QA and Enterprise for date function
-
Hello friends!!
I have one column: DateDay Date(8) in my table
when i write
select DateDay from emp
in both sql analyaser and sql enterprise manager i got answers like that
in analyaser : 2005-08-30 02:41:04.000
and in enterprise manager like : 8/30/2005 2:41:04 AM
in enterprise manager it is not showing in milliseconds why?
or any setting should i change
nothing issue with this but just as knowlege purpose i am asking
T.I.A
Shashank
Regards,
Papillon
-
afaik it is because the EM implicitly uses the "regional settings" whereas in the Query Analzyer, unless you set the connections options under "Tools" to "use regional settings when displaying currency, number, dates and times" it does not display the locale settings!!!
**ASCII stupid question, get a stupid ANSI !!!** -
Hey
i got your point !!!
just one small question if i want the same output in EM as i got in QA then will
it possible i.e 2005-08-30 02:41:04.000
T.I.A
Shashank
Regards,
Papillon
-
shashank - again - as far as I know - this is not possible!
That being said - why would you want to change the EM display - what really matters is how you output the results to your application, QA etc..and that you do have control over!!!
**ASCII stupid question, get a stupid ANSI !!!** -
Hey !
Any way thanks sushila
Take care
Shashank
Regards,
Papillon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply