Insert current system date 1

[dolodolo]

Hi,

I am trying to populate a field with the current system date. here is my insert statement. Could someone help me with what the code is for the timestamp field?

Thanks

INSERT into ARCHIVE_CMRevision (cmhmy, hjob, hcat, ic, camt, dtdate, sapproved, sreason, bxfer, bpost, hjd,
hGroupID, husercreatedby, dRevNum, iStatus, sBudgetVersion, dtArchiveDate)
(SELECT
cm.hmy,
cm.hjob,
cm.hcat,
cm.ic,
cm.camt,
cm.dtdate,
cm.sapproved,
cm.sreason,
cm.bxfer,
cm.bpost,
cm.hjd,
cm.hgroupid,
cm.husercreatedby,
cm.dRevNum,
cm.iStatus,
'COE',
timestamp
FROM
CMREVISION cm
WHERE cm.hjob in (1327, 1328))

 

[RiverGuy]

GETDATE() returns the current date/time.