Re: Missing: hour/minute / second data (smalldatetime)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The way it is displayed depends on the gui that is displaying it unless you
have formatted it into a string with CONVERT().

--
Andrew J. Kelly SQL MVP


"Justin Doh" <JustinDoh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D7448E86-7DF3-4D41-BC78-C9FF03B7CCF1@xxxxxxxxxxxxxxxx
> Thank you Thomas.
>
> I was able to find the difference with Query Analyzer, and it looked as
>
> 2005-10-03 00:00:00.
>
> I think that is good catch and my learning experience.
>
> Question: Why then this does not appear as
>
> " 10/3/2005 12:00:00 AM " instead?
>
>
>
> "Thomas Bradshaw via SQLMonster.com" wrote:
>
>> Justin,
>>
>> A couple questions:
>>
>> 1) What does the source time say? Any way of examining those fields to
>> see
>> why they behave as they do?
>>
>> 2) How are you viewing the column? I get your described behavior when
>> opening the table in Enterprise Manager. The date/time rows with the
>> time
>> missing are the ones that start at midnight.
>>
>> Try viewing the table in Query Analyzer to see if they are truly missing.
>> Let us know how you make out.
>>
>> Thomas Bradshaw
>> Data Integration Specialist
>> MyWebGrocer.com
>>
>>
>> --
>> Message posted via http://www.sqlmonster.com
>>


.

Relevant Pages

  • Re: Missing: hour/minute / second data (smalldatetime)
    ... What does the source time say? ... why they behave as they do? ... Try viewing the table in Query Analyzer to see if they are truly missing. ...
    (microsoft.public.sqlserver.dts)
  • Page unload event
    ... I have a web form in my application that will be used for both viewing and ... updating information. ... It seemed logical to put any code to handle this in the page unload event, ... I attempted to check for IsPostBack, before displaying the save message. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Word 2003 document not displaying properly in Word 2007
    ... Usually they are images copied out of a PDF. ... of the images are displaying as black rectangles. ... What am I missing? ...
    (microsoft.public.office.misc)
  • Re: request_uri alternative
    ... It is displaying the page viewing and not the page it was ... approach would be to rewrite the URLs in all the links using ... The reason for this was to be able to put the user back on the page after a link took him elsewhere. ... It was my thought that it held the value of the page the linked the page I am viewing. ...
    (comp.lang.php)
  • Re: Display file version in Terminal?
    ... specifying any flags or parameters then, in general, does it prompt for missing values or does it respond by displaying the proper syntax for that command's invocation? ...
    (comp.sys.mac.system)