>Hello,
>
>I have an INSERT into command where a DateTime column gets a Date without a time. The Date is passed to this method. So, right now, when I look at this column (in SQL Server Management Studio), I see date and all 0 (zeros) for the time. I would like the INSERT to store the current time when this happens.
>How do I do it in code? Here is an example of the INSERT:
>

>	INSERT INTO (cInvenUsedView) ( INVEN_PK, INV_CODE, TRAN_DATE ) VALUES ;
>		( tnInvenPk, cInvCode, tdPostDate  )
>

>
>The value in the above variable tdPostDate is a Date. Can I add the Time right in this SQL Insert?

A minimalistic approach to this would be

	INSERT INTO (cInvenUsedView) ( INVEN_PK, INV_CODE, TRAN_DATE ) VALUES ;
		( tnInvenPk, cInvCode, dtot(tdPostDate)+seconds()  )