Doris Manning
mikedorism at verizon.net
Wed Oct 18 10:10:08 CDT 2006
Charlotte, I agree with you 100%. Paul, the reason you are having problems is that SQL Server doesn't allow you to store just a time in a date/time field. If you don't provide the date portion, SQL Server will fill in that portion with 1/1/1900. Doris Manning -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, October 18, 2006 11:00 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Updating DateTime Field IN SQL Server WithJust The Time I don't understand what purpose is served by inserting only a time. Without a date, the time is pretty meaningless. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of paul.hartland at fsmail.net Sent: Wednesday, October 18, 2006 7:00 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Updating DateTime Field IN SQL Server WithJust The Time Importance: High 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com Paul Hartland paul.hartland at fsmail.net 07730 523179 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com