- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:datetime:adodb_strftime

# adodb_strftime

##### See Also

PHP Function strftime()

##### Syntax

    string adodb_strftime(
      string $fmt,
      optional int $timestamp = false
      )

## Description

This function converts a timestamp to a formatted local date. Internally converts $fmt into adodb_date format, then echo result.

For best results, you can define the local date format yourself by defining a global variable $ADODB_DATE_LOCALE

## Usage

    $t = adodb_mktime(12,10,0,6,20,1066);
    print $t;
    /*
    * Prints -28512215400
    */
    $d = adodb_strftime("%b %d %Y %H:%M:%S", $t) . "\n";
    print $d;
    /*
    * Prints Jun 20 1066 12:10:00
    */

## Supported format codes

    %a - abbreviated weekday name according to the current locale
    %A - full weekday name according to the current locale
    %b - abbreviated month name according to the current locale
    %B - full month name according to the current locale
    %c - preferred date and time representation for the current locale
    %d - day of the month as a decimal number (range 01 to 31)
    %D - same as %m/%d/%y
    %e - day of the month as a decimal number,
         a single digit is preceded by a space (range ' 1' to '31')
    %h - same as %b
    %H - hour as a decimal number using a 24-hour clock (range 00 to 23)
    %I - hour as a decimal number using a 12-hour clock (range 01 to 12)
    %m - month as a decimal number (range 01 to 12)
    %M - minute as a decimal number
    %n - newline character
    %p - either `am' or `pm' according to the given time value,
         or the corresponding strings for the current locale
    %r - time in a.m. and p.m. notation
    %R - time in 24 hour notation
    %S - second as a decimal number
    %t - tab character
    %T - current time, equal to %H:%M:%S
    %x - preferred date representation for the current locale without the time
    %X - preferred time representation for the current locale without the date
    %y - year as a decimal number without a century (range 00 to 99)
    %Y - year as a decimal number including the century
    %Z - time zone or name or abbreviation
    %% - a literal `%' character

## Unsupported Formats

    %C - century number (the year divided by 100 and truncated to an integer,
         range 00 to 99)
    %g - like %G, but without the century.
    %G - The 4-digit year corresponding to the ISO week number (see %V).
         This has the same format and value as %Y, except that if the ISO
         week number belongs to the previous or next year, that year is used instead.
    %j - day of the year as a decimal number (range 001 to 366)
    %u - weekday as a decimal number [1,7], with 1 representing Monday
    %U - week number of the current year as a decimal number, starting
        with the first Sunday as the first day of the first week
    %V - The ISO 8601:1988 week number of the current year as a decimal number,
         range 01 to 53, where week 1 is the first week that has at least 4 days in the
         current year, and with Monday as the first day of the week. (Use %G or %g for
         the year component that corresponds to the week number
         for the specified timestamp.)
    %w - day of the week as a decimal, Sunday being 0
    %W - week number of the current year as a decimal number, starting with the
         first Monday as the first day of the first week

v5/datetime/adodb_strftime.txt · Last modified: 2016/01/12 17:12 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top