Professional Web Applications Themes

Time/Date format and changing time to GMT - ASP

Hi All, Sorry if this is the wrong newsgroup to post into, on this topic, if so, please point me in the right direction..... Currently working on a ASP for a friend, which requires the date and time on it. It pulls in entries from an Access Database with dates and times in the format of: "Fri Oct 17 18:02:46 2003" However my date and time on the ASP page is displayed as: "Friday, October 17, 2003 18:02:46" using the script: "<%Session.LCID = 1033%> <%=FormatDateTime(Date(), vbLongDate)%> <%Session.LCID = 2057%> <%=time()%>" Anyone know how to change this script, fully or partly ...

  1. #1

    Default Time/Date format and changing time to GMT

    Hi All,

    Sorry if this is the wrong newsgroup to post into, on this topic, if so, please
    point me in the right direction.....

    Currently working on a ASP for a friend, which requires the date and
    time on it. It pulls in entries from an Access Database with dates and
    times in the format of:
    "Fri Oct 17 18:02:46 2003"
    However my date and time on the ASP page is displayed as:
    "Friday, October 17, 2003 18:02:46"
    using the script:
    "<%Session.LCID = 1033%>
    <%=FormatDateTime(Date(), vbLongDate)%>
    <%Session.LCID = 2057%>
    <%=time()%>"

    Anyone know how to change this script, fully or partly to produce the
    date and time on the format that's in the access database i.e. "Fri Oct 17
    18:02:46 2003"

    Also, as the ASP host I'm using in based in the US (Norfolk I believe),
    it is displaying the time not as GMT which the web site would be viewed
    in, anyway of changing this?

    Thanks for any help.

    --
    Cheers
    Shai Boy
    (Remove NOSPAM from email address)


    Shaiboy_UK Guest

  2. #2

    Default Re: Time/Date format and changing time to GMT

    Shaiboy_UK wrote:
    > Hi All,
    >
    > Sorry if this is the wrong newsgroup to post into, on this topic, if
    > so, please point me in the right direction.....
    >
    > Currently working on a ASP for a friend, which requires the date and
    > time on it. It pulls in entries from an Access Database with dates
    > and
    > times in the format of:
    > "Fri Oct 17 18:02:46 2003"
    Date/Times are not stored with any format. In an Access database, date/times
    are stored as Doubles, with the whole number portion representing the number
    of days since the seed date, and the decimal portion representing the time
    of day (.5 = noon). It is up to the client (the application that is pulling
    the data from the database) to apply any formatting. With ASP, the regional
    settings for the IUSR or IWAM account (depending on where the code is
    running) are used.
    > However my date and time on the ASP page is displayed as:
    > "Friday, October 17, 2003 18:02:46"
    > using the script:
    > "<%Session.LCID = 1033%>
    > <%=FormatDateTime(Date(), vbLongDate)%>
    > <%Session.LCID = 2057%>
    > <%=time()%>"
    >
    > Anyone know how to change this script, fully or partly to produce the
    > date and time on the format that's in the access database i.e. "Fri
    > Oct 17 18:02:46 2003"
    >
    [url]http://www.aspfaq.com/show.asp?id=2313[/url]
    > Also, as the ASP host I'm using in based in the US (Norfolk I
    > believe),
    > it is displaying the time not as GMT which the web site would be
    > viewed
    > in, anyway of changing this?
    >
    [url]http://www.aspfaq.com/show.asp?id=2218[/url]

    HTH,
    Bob Barrows

    --
    Microsoft MVP - ASP/ASP.NET
    Please reply to the newsgroup. This email account is my spam trap so I
    don't check it very often. If you must reply off-line, then remove the
    "NO SPAM"


    Bob Barrows Guest

Similar Threads

  1. date/time format
    By kt03 in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: September 17th, 01:51 AM
  2. Date/Time format with MS Access & CF
    By rapcgtiac in forum Macromedia ColdFusion
    Replies: 2
    Last Post: May 12th, 07:25 PM
  3. DW date & time format
    By samkry in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 12th, 10:25 AM
  4. Nautulus: time/date format change ?
    By R@LF in forum Linux Setup, Configuration & Administration
    Replies: 3
    Last Post: August 9th, 07:16 AM
  5. Date/Time Format?
    By Aaron Bertrand - MVP in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 07:31 PM

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