FICO
FICO Xpress Optimization Examples Repository
FICO Optimization Community FICO Xpress Optimization Home
Back to examples browserPrevious exampleNext example

Reading and writing dates and times

Description
This set of examples shows how to work with date and time data types when accessing data in spreadsheets and databases. The basic model version uses an ODBC connection to databases through the odbc driver, model version (2) uses ODBC through SQL statements and version (4) shows the same for Oracle databases accessed via the OCI. Model versions (3) and (5) work with different spreadsheet drivers, and version (6) with CSV data format.

Further explanation of this example: Xpress Whitepaper 'Using ODBC and other database interfaces with Mosel', Section Examples - Handling dates and time.

datetime.zip[download all files]

Source Files
By clicking on a file name, a preview is opened at the bottom of this page.
datesinout.mos[download]
datesinout2.mos[download]
datesinout3.mos[download]
datesinout4.mos[download]
datesinout5.mos[download]

Data Files
datetime.csv[download]
recorddata2.csv[download]
datetime.xls[download]
datetime.xls[download]




datesinout5.mos

(!******************************************************
   Mosel Example Problems
   ====================== 

   file datesinout5.mos
   ````````````````````
   Reading/writing dates from/to spreadsheets.
   - Using 'initializations from' with the xsl driver -
   
   (c) 2012 Fair Isaac Corporation
       author: S. Heipcke, Dec. 2012, rev. Sep. 2014
*******************************************************!)

model "Dates and times (spreadsheet)"
 uses "mmsystem", "mmsheet"

 parameters
  CSTR = 'mmsheet.xls:datetime.xls'
!  CSTR = 'mmsheet.xlsx:datetime.xlsx'
 end-parameters

 declarations
  T: time
  D: date
  DT: datetime
  Dates: array(1..5) of date
  DList: list of date
 end-declarations

! Read in dates / time (make sure to use the default format of mmsystem,
! not the format used for display in the spreadsheet)
 setparam("timefmt", "%0H:%0M:%0S")
 setparam("datefmt", "%.y-%0m-%0d")
 setparam("datetimefmt", "%.y-%0m-%0dT%0H:%0M:%0S")

 initializations from CSTR
  T as "skiph;Time1"
  D as "skiph;Date1"
  DT as "skiph;DateTime1"
  Dates as "skiph;noindex;Dates"
  DList as "skiph;Dates"
 end-initializations

 writeln(D, ", ", T)
 writeln(DT)
 writeln(Dates)

! Read date / time from strings
 setparam("timefmt", "%Hh%0Mm")
 setparam("datefmt", "%dm%0my%0y")
 setparam("datetimefmt", "%dm%0my%0y, %Hh%0Mm")

 initializations from CSTR
  T as "skiph;Time2"
  D as "skiph;Date2"
  DT as "skiph;DateTime2"
 end-initializations

 writeln(D, ", ", T)
 writeln(DT)

! Use Mosel's default format
 setparam("timefmt", "")
 setparam("datefmt", "")
 setparam("datetimefmt", "")

 writeln(D, ", ", T)
 writeln(DT)

 initializations to CSTR
  T as "TimeOutE"
  D as "DateOutE"
  DT as "DateTimeOutE"
 end-initializations

end-model
Back to examples browserPrevious exampleNext example
© Copyright 2024 Fair Isaac Corporation.