function init(request) {
    var inputDateStr = request.inputDate; //Date and time string sent from screen
    var formatIds = {
        AccountDateTimeFormatter.IM_DATETIME_FORMAT_DATE_INPUT,
        AccountDateTimeFormatter.IM_DATETIME_FORMAT_TIME_INPUT
    };
    var inputDate = AccountDateTimeFormatter.parseToDate(inputDate, formatIds);
}

var db = new TenantDatabase();
var userCd = Contexts.getAccountContext().userCd;
Transaction.begin(function() {
    db.execute('INSERT INTO example_table values(?, ?)', [DbParameter.string(userCd), DbParameter.timestamp(inputDate)]);
});

function init(request) {
    var inputDateStr = request.inputDate; //Date string sent from screen
    var inputDate = AccountDateTimeFormatter.parseToDate(inputDate, AccountDateTimeFormatter.IM_DATETIME_FORMAT_DATE_INPUT);
}

var db = new TenantDatabase();
var userCd = Contexts.getAccountContext().userCd;
var result = db.select('SELECT update_date FROM example_table WHERE user_cd=?', [DbParameter.string(userCd)]);
if (result.error) {
    return;
}
var outputDate = result.data[0];

var formatIds = {
    AccountDateTimeFormatter.IM_DATETIME_FORMAT_DATE_STANDARD,
    AccountDateTimeFormatter.IM_DATETIME_FORMAT_TIME_STANDARD
}
var outputDateStr = AccountDateTimeFormatter.format(outputDate, formatIds);

Sep 19, 2012 3:46 AM

var outputDateStr = AccountDateTimeFormatter.format(outputDate, AccountDateTimeFormatter.IM_DATETIME_FORMAT_DATE_STANDARD);

Sep 19, 2012

Warning

Do not use new Date of csjs for fetching “Today” in user time zone.

newDate of csjs returns the current date and time data in time zone of client OS. However, user time zone may not necessarily match with the client OS time zone.

<script type="text/javascript" src="im_i18n/timezone/im_date_timezone.js"></script>
<script type="text/javascript">
var firstDate = ImDate.now();
</script>

var dateArray = new Array();
var date = firstDate;
for (var i = 0; i < 3; i++) {
    dateArray[i] = date;
    date.setDate(date.getDate() + 1);
}

var lastDate = dateArray[2];
var lastDateStr = lastDate.getFullYear() + "-" + (lastDate.getMonth() + 1) + "-" + lastDate.getDate();

Warning

Do not send Epoch milliseconds of Date created by ImDate.now().

The Date which is returned by ImDate.now() has date time seconds of “Today” in user time zone. However, Epoch milliseconds are not necessarily right.

The reason is that the Date is created at the client side.

The value calculated according to the user time zone may not match with the Epoch milliseconds of Date which is calculated according to the time zone of the client time zone.

Warning

Use DateTime when creating date and time data of user time zone at the server side. Do not use Date only.

It is important to consider the time difference between user’s time zones to calculate the Date according to the system/default time zone.

DateTime is calculated according to the user’s time zone if time zone is not specified.

//Date and time data on 19th September 1996,3:47 in user timezone
var dateTime = new DateTime(1996, DateTime.SEPTEMBER, 19, 3, 47, 0);

function init(request) {
    var inputDateStr = request.inputDate; //Date string sent from the screen
    var inputDate = DateTimeFormatter.parseToDate('yyyy-MM-dd', inputDateStr);
}