asked on

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?

Kevin Hill

datetime or smalldatetime?

RLLewis

ASKER

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.

rafrancisco

Where are you getting this result? From Enterprise Manager or Query Analyzer or some other application?

RLLewis

ASKER

2005-05-12 00:00:00.000 - from query analyzer - oh, possibly my result options?

Kevin Hill

Some apps, like Access don't always pass in the time....

ASKER CERTIFIED SOLUTION

rafrancisco

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RLLewis

ASKER

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 ?

RLLewis

ASKER

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

rafrancisco

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?

RLLewis

ASKER

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