RE: Problem storing date and time in one column
From: David J (DavidJ_at_discussions.microsoft.com)
Date: 07/28/04
- Next message: Urs Eichmann: "VB 2005 beta testers... please read, vote and comment on this issue"
- Previous message: Steve Flitcroft: "Re: Excel Process still running"
- In reply to: JMW: "RE: Problem storing date and time in one column"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 02:02:06 -0700
Hi Jason,
I am currently using my app against access but I have the same problem using sql-server. It is only the date that is stored. This is the insert parameter I am using:
OleDSIns2.Parameters.Add(New OleDb.OleDbParameter("CREATED_STAMP", OleDb.OleDbType.DBDate, 0, "CREATED_STAMP"))
I tried to change the oledbtype to dbtime, date, dbtimestamp as well but that all didn't work
Thanks
"JMW" wrote:
> My first question would be to actually see the value stuff into the database. SQL Server will only show the date when queried but the entire date and time are actually stored.
>
> jason.
>
> "David J" wrote:
>
> > Hi,
> > I am trying to store a datetime value in a column of a table. I am using the code generated by the dataform wizard. However when I insert a new line with a new created date and time I only get the date stored and not the time. The setting of the field in the dataset is datetime. I am using Now to get the correct time. The insert command parameter is of the type oledbdate. I have also tried with oledbTime and oledbTimestamp but I do not succeed.
> >
> > Can anyone give me a suggestion?
> >
> > Thanks
> >
> > David J
- Next message: Urs Eichmann: "VB 2005 beta testers... please read, vote and comment on this issue"
- Previous message: Steve Flitcroft: "Re: Excel Process still running"
- In reply to: JMW: "RE: Problem storing date and time in one column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
