Home / QIN / Examples / Example: How to use the msInUTC parameter

Examples

Examples of how to extend QuickBase

Example: How to use the msInUTC parameter

In this example:

  • your billing account is set to use PST

  • you have a table where field 7 is a DTM field

If you issue this API call without using the msInUTC parameter:

?a=API_AddRecord&_fid_7=1267642263823

…QuickBase interprets the value for field 7 as milliseconds in PST. If you then display the record you added, QuickBase displays this value: 03-03-2010 06:51 PM . (The display is always in application local time).

If instead you include the msInUTC parameter and issue this API call:

?a=API_AddRecord&_fid_7=1267642263823&msInUTC=1

…Quickbase interprets the value for field 7 as milliseconds in UTC. If you then display the record you added, QuickBase displays this value:03-03-2010 10:51 AM

Tags:

Rate This

Your rating: None Average: 1 (1 vote)

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit