[AccessD] Updating DateTime Field IN SQL Server With Just The Time

Gustav Brock Gustav at cactus.dk
Wed Oct 18 13:45:46 CDT 2006


Hi Paul

As already noted there is no such thing as a "time only" date/time value. Given no date, the date value of a date/time value equals 1899-12-30 which is numeric 0 and normally isn't displayed by Access. 
Why you get 1900-01-01 which is numeric 2, I don't know. Nothing strange about your SP as far as I can see, but at the moment I have no running SQL Server to test with.

/gustav

>>> paul.hartland at fsmail.net 18-10-2006 16:00:17 >>>
Gustav,

Here's a test one I have been playing with, can't get more simple really....Even tried using CONVERT in the stored procedure and Format from Visual Basic 6.0
CREATE PROCEDURE [insert_timetable_1]
 (@TestTime_1  [datetime])
AS INSERT INTO [Genesis].[dbo].[timetable] 
  ( [TestTime]) 
 
VALUES 
 ( @TestTime_1)
GO

The date is always 01/01/1900

Paul




Message Received: Oct 18 2006, 01:44 PM
From: "Gustav Brock" 
To: accessd at databaseadvisors.com 
Cc: 
Subject: Re: [AccessD] Updating DateTime Field IN SQL Server With Just The Time

Hi Paul

So what does your stored procedure look like?
Which date is stored with the time? Today's date?

/gustav

>>> paul.hartland at fsmail.net 18-10-2006 13:51:46 >>>
To all,

I have a little problem which I am sure this group can tell me the answer to....I have a datetime field in SQL Server 2000 I have an insert stored procedure which I pass the time to to put into the table, however it always puts the date in front of the time....I can input the time directly and no date gets put in front, I can also use a recordset with an update which works (but is slower)....Is there anyway I can insert a time into a datetime field in SQL Server 2000 without it putting the date in front using a stored procedure.

Thanks in advance for any help on this as it's driving me nuts.


Paul Hartland 
paul.hartland at fsmail.net 
07730 523179




More information about the AccessD mailing list