>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?
>
>TIA

How 'bout something like:

	IF VARTYPE(tdPostDate)=="T" THEN
		* tdPostDate is already a DateTime value
		INSERT INTO (cInvenUsedView) ( INVEN_PK, INV_CODE, TRAN_DATE ) VALUES ;
			( tnInvenPk, cInvCode, tdPostDate  )
	ELSE
		IF VARTYPE((tdPostDate)=="D" THEN
			* tdPostDate is a Date value - add current time
			tNow = DATETIME()
			ttPostDate = DATERTIME(YEAR(m.tdPostDate),MONTH(m.tdPostDate),DAY(m.tdPostDate), HOUR(m.tNow),MINUTE(m.tNow),SEC(m.tNow))
			INSERT INTO (cInvenUsedView) ( INVEN_PK, INV_CODE, TRAN_DATE ) VALUES ;
				( tnInvenPk, cInvCode, ttPostDate  )
		ENDIF
	ENDIF