niota

fascinating. logical.

User Tools

Site Tools


niota-docs:niota_sample_values

This is an old revision of the document!


database character set

  • AL32UTF8 - Oracle UTF8
  • iso-8859-2 - Windows typical western character set
  • UTF-8

DATE and DATETIME formats: * Y year, 4 digits * y year 2 digits * m month, numeric (00-12) * M month name (January-December) * d day of month, numeric (00-31) * H hour (00-23) * h,I hour (01-12) * i minutes, numeric (00-59) * s,S seconds (00-59) * p am/pm * r time, 12-hour (hh:mm:ss) followed by AM or PM) * T time, 24 hour (hh:mm:ss) * f microseconds (000000-999999) * b month, numeric (00-12) only for Oracle connections

niota-docs/niota_sample_values.1636884150.txt.gz · Last modified: 2025/07/17 14:11 (external edit)