```SELECT ID TranID Type TranDate TO CHAR TranDate DS TS FRO NetSuite Professionals #suiteql

```SELECT ID, TranID, Type, TranDate, TO_CHAR...

tdietrich

06/08/2021, 2:18 PM

Copy code

SELECT
	ID,
	TranID,
	Type,
	TranDate,
	TO_CHAR ( TranDate, 'DS TS' )
FROM
	Transaction
WHERE
	TO_CHAR ( TranDate, 'DS' ) = TO_CHAR ( SYSDATE, 'DS' )