This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

use <https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/TO_CHAR-datetime.html|TO_CHAR>

Here are some examples of format models that you can use with TO_CHAR:
```SELECT
	TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:MI:SS' ) AS CurrentSystemTimestamp,
	TO_CHAR ( SYSDATE, 'SSSSS' ) AS SecondsSinceMidnight,	
	TO_CHAR ( SYSDATE, 'RM' ) AS MonthRoman,
	TO_CHAR ( SYSDATE, 'MM' ) AS CurrentMonth,
	TO_CHAR ( SYSDATE, 'MONTH' ) AS CurrentMonthName,	
	TO_CHAR ( SYSDATE, 'DD' ) AS CurrentDay,
	TO_CHAR ( SYSDATE, 'DAY' ) AS CurrentDayName,
	TO_CHAR ( SYSDATE, 'YYYY' ) AS CurrentYear,
	TO_CHAR ( SYSDATE, 'YEAR' ) AS CurrentYearName,
	TO_CHAR ( SYSDATE, 'Q' ) AS CurrentQuarter,
	TO_CHAR ( SYSDATE, 'WW' ) AS WeekNumber
FROM
	Dual```