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