Professional Web Applications Themes

How to format TIMESTAMP column?? - PHP Development

Hi, Would anyone be kind enough to supply an echo statemt which will format a TIMESTAMP mysql column as HH:MM, DD/MM/YY Thanks :-)...

Sponsored Links
  1. #1

    Default How to format TIMESTAMP column??

    Hi,

    Would anyone be kind enough to supply an echo statemt which will
    format a TIMESTAMP mysql column as

    HH:MM, DD/MM/YY

    Thanks :-)


    Sponsored Links
    Blobby J Blobdom Guest

  2. #2

    Default Re: How to format TIMESTAMP column??

    Blobby J Blobdom <blobblob.com> wrote:
    > Would anyone be kind enough to supply an echo statemt which will
    > format a TIMESTAMP mysql column as
    >
    > HH:MM, DD/MM/YY
    SELECT DATE_FORMAT(timestampcolumn, '%H:%i, %d/%m/%Y') AS formattedDate FROM
    tablename

    HTH;
    JOn

    Jon Kraft Guest

  3. #3

    Default Re: How to format TIMESTAMP column??

    You can get the mySQL timestamp in UNIX timestamp format like so

    SELECT UNIX_TIMESTAMP(time) AS u_timestamp

    the field u_timestamp would then be the unix timestamp of time (the mysql
    timestamp)

    --
    Hades

    "Blobby J Blobdom" <blobblob.com> wrote in message
    news:i550pv0q9b3qnr561u67d3lq10enb55kbu4ax.com...
    > Hi,
    >
    > Would anyone be kind enough to supply an echo statemt which will
    > format a TIMESTAMP mysql column as
    >
    > HH:MM, DD/MM/YY
    >
    > Thanks :-)
    >
    >

    Hades Guest

  4. #4

    Default Re: How to format TIMESTAMP column??

    On Fri, 17 Oct 2003 17:34:17 +0100, Jon Kraft <jonjonux.co.uk> wrote:
    >SELECT DATE_FORMAT(timestampcolumn, '%H:%i, %d/%m/%Y') AS formattedDate FROM
    >tablename
    Thank you :-)


    Blobby J Blobdom Guest

Similar Threads

  1. Inserting both date AND time into one timestamp column
    By orionMX in forum Coldfusion Database Access
    Replies: 3
    Last Post: October 29th, 05:34 PM
  2. Question Timestamp Column in DB2
    By tommy@1987 in forum Databases
    Replies: 0
    Last Post: August 26th, 09:26 AM
  3. How can I format a number column in a datagrid
    By Arne in forum ASP.NET Data Grid Control
    Replies: 4
    Last Post: January 6th, 02:37 PM
  4. Format Phone Number String in Datagrid Column
    By Dave in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: December 6th, 01:49 PM
  5. How to format a boolean column to show YES/NO
    By Jos in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: August 6th, 11:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139