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 date-time format characters

  • 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.1636884194.txt.gz · Last modified: 2025/07/17 14:11 (external edit)