Shaiboy_UK wrote:Date/Times are not stored with any format. In an Access database, date/times> 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
> times in the format of:
> "Fri Oct 17 18:02:46 2003"
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.
[url]http://www.aspfaq.com/show.asp?id=2313[/url]> 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%>
> 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=2218[/url]> Also, as the ASP host I'm using in based in the US (Norfolk I
> it is displaying the time not as GMT which the web site would be
> in, anyway of changing this?
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