is there a way to get the timestamp (date + time) for createddate on a transaction using N/Query? I'm trying

SELECT createddate FROM transaction

but it's only giving back the date (not the time).

nlapiGetFieldValue('createddate')

gives both date & time.

use TO_CHAR to format it how you want