OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
Overview Quick start Download Manual How to buy FAQ Contact Us
OZEKI NG SMS Gateway - Product Guide

Pervasive SQL Contents | SearchScheduled SMS

Home > Product Manual > Installation Guide > Users and applications > Database user > Date Format Strings

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  Service Provider Connections
  Users and applications
  Standard user
  SMPP user
  Database user
  MSSQL
  MySQL
  Oracle
  Sybase SQL Anywhere
  PostgreSQL
  Pervasive SQL
  Date Format Strings
  Scheduled SMS
  SQL templates
  Informix
  Access
  Video
  Connection string builder
  Keywords
  Batch processing
  SQL statements
  Polling technology
  Dynamic Keywords
  Dynamic SMPP parameters
  AutoreplyDatabase user
  Autoreply user
  AutoReplyEasy user
  File user
  E-mail user
  HTTP Client user
  Colour SMS user
  Appstarter user
  SMS Voting
  Outlook Mobile Service
  FTP user
  PDF user
  WCF Client User
  Forwarder user
  Ozeki NG Autoreply
  Linux
  User Guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 
Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

Date Format Strings to be used in SQL SMS configurations


This page provides you with date format strings you can use if you want to change the default date format string in the configuration of the Database user of the Ozeki NG - SMS Gateway software.

When configuring the Database user of Ozeki NG - SMS Gateway, you can specify the date format string used to create the date value for the SQL statements. (See Figure 5 and the instructions below it on the Database User page.)

If you would like to change the default date format string (dd/mm/yyyy hh:mm:ss) in the Database connection tab of the Database user, you can use any of the date format strings below.

You can use a hyphen (-), a period (.), a slash (/) or a space ( ) character to separate format specifiers.

The following formatting characters can be used for date and time formatting:
 
d Represents the day of the month as a number from 1 through 31. A single-digit day is formatted without a leading zero.
dd Represents the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero.
ddd Represents the abbreviated name of the day of the week: "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", and "Sat".
dddd (plus any number of additional "d" specifiers) Represents the full name of the day of the week: "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", and "Saturday".
f Represents the most significant digit of the seconds fraction.
ff Represents the two most significant digits of the seconds fraction.
fff Represents the three most significant digits of the seconds fraction.
ffff Represents the four most significant digits of the seconds fraction.
fffff Represents the five most significant digits of the seconds fraction.
ffffff Represents the six most significant digits of the seconds fraction.
fffffff Represents the seven most significant digits of the seconds fraction.
F Represents the most significant digit of the seconds fraction. Nothing is displayed if the digit is zero.
FF Represents the two most significant digits of the seconds fraction. However, trailing zeros, or two zero digits, are not displayed.
FFF Represents the three most significant digits of the seconds fraction. However, trailing zeros, or three zero digits, are not displayed.
FFFF Represents the four most significant digits of the seconds fraction. However, trailing zeros, or four zero digits, are not displayed.
FFFFF Represents the five most significant digits of the seconds fraction. However, trailing zeros, or five zero digits, are not displayed.
FFFFFF Represents the six most significant digits of the seconds fraction. However, trailing zeros, or six zero digits, are not displayed.
FFFFFFF Represents the seven most significant digits of the seconds fraction. However, trailing zeros, or seven zero digits, are not displayed.
g or gg (plus any number of additional "g" specifiers) Represents the period or era (A.D. for example). This specifier is ignored if the date to be formatted does not have an associated period or era string.
h Represents the hour as a number from 1 through 12, that is, the hour as represented by a 12-hour clock that counts the whole hours since midnight or noon. Consequently, a particular hour after midnight is indistinguishable from the same hour after noon. The hour is not rounded, and a single-digit hour is formatted without a leading zero. For example, given a time of 5:43, this format specifier displays "5".
hh, hh (plus any number of additional "h" specifiers) Represents the hour as a number from 01 through 12, that is, the hour as represented by a 12-hour clock that counts the whole hours since midnight or noon. Consequently, a particular hour after midnight is indistinguishable from the same hour after noon. The hour is not rounded, and a single-digit hour is formatted with a leading zero. For example, given a time of 5:43, this format specifier displays "05".
H Represents the hour as a number from 0 through 23, that is, the hour as represented by a zero-based 24-hour clock that counts the hours since midnight. A single-digit hour is formatted without a leading zero.
HH, HH (plus any number of additional "H" specifiers) Represents the hour as a number from 00 through 23, that is, the hour as represented by a zero-based 24-hour clock that counts the hours since midnight. A single-digit hour is formatted with a leading zero.
m Represents the minute as a number from 0 through 59. The minute represents whole minutes passed since the last hour. A single-digit minute is formatted without a leading zero.
mm, mm (plus any number of additional "m" specifiers) Represents the minute as a number from 00 through 59. The minute represents whole minutes passed since the last hour. A single-digit minute is formatted with a leading zero.
M Represents the month as a number from 1 through 12. A single-digit month is formatted without a leading zero.
MM Represents the month as a number from 01 through 12. A single-digit month is formatted with a leading zero.
MMM Represents the abbreviated name of the month: "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov" and "Dec".
MMMM Represents the full name of the month: "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November" and "December".
s Represents the seconds as a number from 0 through 59. The second represents whole seconds passed since the last minute. A single-digit second is formatted without a leading zero.
ss, ss (plus any number of additional "s" specifiers) Represents the seconds as a number from 00 through 59. The second represents whole seconds passed since the last minute. A single-digit second is formatted with a leading zero.
t Represents the first character of the A.M./P.M. designator. The A.M. designator is used if the hour in the time being formatted is less than 12; otherwise, the P.M. designator is used.
tt, tt (plus any number of additional "t" specifiers) Represents the A.M./P.M. designator. The A.M. designator is used if the hour in the time being formatted is less than 12; otherwise, the P.M. designator is used.
y Represents the year as at most a two-digit number. If the year has more than two digits, only the two low-order digits appear in the result. If the year has fewer than two digits, the number is formatted without a leading zero.
yy Represents the year as a two-digit number. If the year has more than two digits, only the two low-order digits appear in the result. If the year has fewer than two digits, the number is padded with leading zeroes to achieve two digits.
yyy Represents the year as a three-digit number. If the year has more than three digits, only the three low-order digits appear in the result. If the year has fewer than three digits, the number is padded with leading zeroes to achieve three digits.

Note that for the Thai Buddhist calendar, which can have five-digit years, this format specifier displays all five digits.
yyyy Represents the year as a four-digit number. If the year has more than four digits, only the four low-order digits appear in the result. If the year has fewer than four digits, the number is padded with leading zeroes to achieve four digits.

Note that for the Thai Buddhist calendar, which can have five-digit years, this format specifier renders all five digits.
yyyyy (plus any number of additional "y" specifiers) Represents the year as a five-digit number. If the year has more than five digits, only the five low-order digits appear in the result. If the year has fewer than five digits, the number is padded with leading zeroes to achieve five digits.

If there are additional "y" specifiers, the number is padded with as many leading zeroes as necessary to achieve the number of "y" specifiers.
z Represents the signed time zone offset of your system from Greenwich Mean Time (GMT) measured in hours. For example, the offset for a computer in the Pacific Standard Time zone is "-8".

The offset is always displayed with a leading sign. A plus sign (+) indicates hours ahead of GMT and a minus sign (-) indicates hours behind GMT. The offset ranges from 12 through +13. A single-digit offset is formatted without a leading zero. The offset is affected by daylight savings time.
zz Represents the signed time zone offset of your system from Greenwich Mean Time (GMT) measured in hours. For example, the offset for a computer in the Pacific Standard Time zone is "-08".

The offset is always displayed with a leading sign. A plus sign (+) indicates hours ahead of GMT and a minus sign (-) indicates hours behind GMT. The offset ranges from 12 through +13. A single-digit offset is formatted with a leading zero. The offset is affected by daylight savings time.
zzz, zzz (plus any number of additional "z" specifiers) Represents the signed time zone offset of your system from Greenwich Mean Time (GMT) measured in hours and minutes. For example, the offset for a computer in the Pacific Standard Time zone is "-08:00".

The offset is always displayed with a leading sign. A plus sign (+) indicates hours ahead of GMT and a minus sign (-) indicates hours behind GMT. The offset ranges from 12 through +13. A single-digit offset is formatted with a leading zero. The offset is affected by daylight savings time.
: The time separator.
/ The date separator.
" Quoted string (quotation mark). Displays the literal value of any string between two quotation marks (").
' Quoted string (apostrophe). Displays the literal value of any string between two apostrophe (') characters.
\c The escape character. Displays the character "c" as a literal when that character is preceded by the escape character (\).
Any other character Any other character is copied to the result string, and does not affect formatting.

Dig deeper!
People who read this also read...





Next page: Scheduled SMS
Copyright © 2000 - 2014 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com