Hi

I am trying to run an insert statement but the timestamp field is
giving me an error

INSERT INTO
TBL_INV_TRANS(
INVENTORY_ID,
IN_OUT,
DESCRIPTION,
QUANTITY,
LOCATION_ID,
COST_PRICE,
JOB_CARD_ID,
DATE_TIME,
USER_NAME,
SELLING_PRICE,
ITEM_DISCOUNT,
DELIVERED)
SELECT TBL_JOB_CARD_INVENTORY.INVENTORY_ID,
'Out',
'Sale',
TBL_JOB_CARD_INVENTORY.QUANTITY,
1,
TBL_JOB_CARD_INVENTORY.JOB_CARD_ID,
CAST(TBL_JOB_CARD.DATE_TIME AS TIMESTAMP),
TBL_JOB_CARD.USER_NAME,
TBL_JOB_CARD_INVENTORY.COST_PRICE,
TBL_JOB_CARD_INVENTORY.SELLING_PRICE,
TBL_JOB_CARD_INVENTORY.ITEM_DISCOUNT,
CASE TBL_JOB_CARD.DOC_TYPE
WHEN'Invoice' THEN 'Yes'
WHEN'Quote' THEN 'No'
WHEN'Job Card' THEN 'No'
END AS REAL_QUANTITY FROM
TBL_JOB_CARD_INVENTORY
INNER JOIN TBL_JOB_CARD
ON TBL_JOB_CARD_INVENTORY.JOB_CARD_ID = TBL_JOB_CARD.JOB_CARD_ID

Error:
Overflow occurred during data type conversion.Conversion error from
string "2008-06-01 10:39:30.0000".

Any ideas please?