Re: Typed dataset: Time only data in SQL dateTime Field

Stephany,

Thanks for your response. I didn't expect it to not store a date.

I can type in a Time alone directly into a sql DateTime field. It will stay
in that format. I am assuming there is an offset here. Personally I prefer
not to separate date and time...unfortunately that isn't up to me here.

I need to retain the format as it was in access. I was expecting that I
might insert the Time as ‘01/01/1753 21:45’ to attain 9:45 PM in the table.
It seems that if I can enter it directly into the table that I should some
how be able to provide input to my typed dataset to replicate the behavior.
I also noticed that the Sql import was able to replicate this format.

I think this should be possible

If anyone has any ideas I would appreciate them

Thanks,

Jeff


"Stephany Young" wrote:

You have a misunderstanding of what the DateTime type is.

It NEVER contains just a date part.

It NEVER contains just a time part.

It ALWAYS contains both date and time parts.

When you come to use the value from the datatabale, YOU may expect only to
use the time part and format the result for display purposes accordingly.

Although the DateTime data type in a Jet database can contain values from
01/01/100 00:00:00 to to 31/12/9999 23:59:59, the datetime datatype in SQL
Server can only contain values from 01/01/1753 00:00:00.000 to 31/12/9999
23:59:59.997.

It is up to you to, before updating the datatable, to ensure that the
datetime variable has a valid datepart >= 01/01/1753.


"JeffDotNet" <JeffDotNet@xxxxxxxxxxxxxxxxx> wrote in message
news:89C0A3A5-994F-4C13-885B-F146F6D47E6B@xxxxxxxxxxxxxxxx
I have an application that needs to insert records into a datatable via a
typed dataset. We are in the process of moving from access to Sql 2000. A
copy of the table exists in access and in sql2000.

I now have 2 typed datasets one pointing to a table in access and one
pointing to an identical table in sql 2000. In this datatable there is a
DateTime field expected to have only a time in it. When I insert records
using the access dataset it works as expected

insert (myTime.ToShortTimeString,yada,yada,yada)

However the same call when using the sql 2000 dataset throws an exception
saying that the date is out of range. How can I supply my sql 2000 typed
dataset to insert just the Time into the datetime field. Do I need to
perform a date time subtraction?

Any help on this would be greatly appreciated,

Thanks,
Jeff




.

Relevant Pages

  • Re: Storing only timepart in Sql server datetime
    ... I'm using a DateTime field in MS SQL 2000, and by using Delphi's Frac method ... > stuck with setting up a character data type for the time portion only. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problems with querying date field
    ... the datetime datatypes: ... Tibor Karaszi, SQL Server MVP ... > I have a sql table with a datetime field. ... The format of the date in the field is in the format '2004-03-29 15:32:00.000' ...
    (microsoft.public.sqlserver.programming)
  • Re: Information between specific dates
    ... a dateTime field. ... After you answer that perhaps you can post the SQL view of your query. ... Access MVP 2002-2005, 2007-2008 ... Center for Health Program Development and Management ...
    (microsoft.public.access.queries)
  • Problems with querying date field
    ... I have a sql table with a datetime field. ... I am having real difficulty querying to that table using a data. ... The format of the date in the field is in the format '2004-03-29 15:32:00.000' ...
    (microsoft.public.sqlserver.programming)
  • Re: UPDATING/INSERTING DATETIME FIELDS FROM ASP?
    ... I think I will need to use calculations at some point, is there a way to pass the Nowvalue into the datetime field. ... I would have used the timestamp but it isn't available on my SQL server. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
Loading