Question: In the access I'm only getting the date `5/12/2015` but no the time, I need something like this

`5/12/2015 4:56 PM` saved in the access database

```
  DateTime dtclickdate = DateTime.Now;
  OleDbParameter clickdate = new OleDbParameter("@clickdate ", OleDbType.DBDate);
  clickdate.Value = dtclickdate; 
  cmd.Parameters.Add(clickdate);

```

Answer: 
You should use the `OleDbType.DBTimeStamp` enumeration, which maps to `DateTime`:

```
DateTime dtclickdate = DateTime.Now;
OleDbParameter clickdate = new OleDbParameter("@clickdate ", OleDbType.DBTimeStamp);
clickdate.Value = dtclickdate; cmd.Parameters.Add(clickdate);

```

See [this documentation](https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbtype%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396) for more information.
Try `OleDbType.DBTimeStamp`:

```
DateTime dtclickdate = DateTime.Now;
OleDbParameter clickdate = new OleDbParameter("@clickdate ", OleDbType.DBTimeStamp);
clickdate.Value = dtclickdate; 
cmd.Parameters.Add(clickdate);

```

Reason: this also stores time fraction as explained [here](https://msdn.microsoft.com/en-us/library/system.data.oledb.oledbtype%28v=vs.110%29.aspx).