getdate() default

i have a table w/a datetime field that has a getdate() default.  but the only thing i am getting is the 2005-05-12 00:00:00.000
what do i need to be doing to get the seconds?
LVL 1
RLLewisAsked:
Who is Participating?
 
rafranciscoCommented:
Yes, possibly your result options.  Check under Connections, "User regional settings..."
0
 
Kevin HillSr. SQL Server DBACommented:
datetime or smalldatetime?
0
 
RLLewisAuthor Commented:
datetime -- i've always assumed i would get my time in there, too.  everything i've read says the same.  but it's not happening.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
rafranciscoCommented:
Where are you getting this result?  From Enterprise Manager or Query Analyzer or some other application?
0
 
RLLewisAuthor Commented:
2005-05-12 00:00:00.000 - from query analyzer - oh, possibly my result options?
0
 
Kevin HillSr. SQL Server DBACommented:
Some apps, like Access don't always pass in the time....
0
 
RLLewisAuthor Commented:
should it be checked or  not?
i had an issue the other day where my sequencenumber colums were appearing as money (10,000,000) as opposed to reguarly identity int value (10000000) - i unchecked regional and they're good now. how is this impacting my datetime ?
0
 
RLLewisAuthor Commented:
i must be missing something.  i've checked regional, and my datetime is now showing my seconds - 3/22/2005 1:29:46 PM
but the sequencenumber has become this:  1,000.00
0
 
rafranciscoCommented:
If you checked the Regional setting, all numeric values are shown as 1,000.00 format, regardless of the data type.  If it is unchecked, it will be displayed as 1000.

Now, the weird part that is happening to you is the missing time in the date/time when it is unchecked.  Have you tried closing your Query Analyzer and trying it again?
0
 
RLLewisAuthor Commented:
well, as much as I hate to say this, yes - i've closed qa, re-opened and now the time is there.  that just doesn't make any sense to me.  but...it's merely a display issue.  at least there's nothing wrong w/the actual data itself.  thx for your help rafran and kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.