Date formatting to iCal Standard.
Question posted by: Jerry Yang
(Guest)
on
September 6th, 2008 12:55 AM
Hi
My DB has 2 fields, one which has the date the other has the time.
The date field is called Appt_Date and has values like 12/03/2008 (DD/
MM/YYYY)
The time field is called Appt_Time and has values like 10:30 (am)
I can retrieve both of these fields from the DB and present them on
screen, but I need to do it in iCAL format.
For example, the following represents Janurary 18, 1998, at 11 PM:
19980118T230000
Any idea how I can do this ?
Thanks
3
Answers Posted
"Jerry Yang" wrote:
Quote:
Originally Posted by
My DB has 2 fields, one which has the date the other has the time.
The date field is called Appt_Date and has values like 12/03/2008 (DD/
MM/YYYY)
No, it doesn't. That might be how they show up when you display them, but I
guarantee you that whatever DB you are using, they are stored in some
unreadable-by-humans internal form. (Well...maybe excepting for MySQL.
Where they will be stored as YYYYMMDD.)
Quote:
Originally Posted by
The time field is called Appt_Time and has values like 10:30 (am)
Ditto.
Quote:
Originally Posted by
For example, the following represents Janurary 18, 1998, at 11 PM:
19980118T230000
Any idea how I can do this ?
Easy, peasy:
<%
....
dt = RS("Appt_Date")
tm = RS("Appt_Time")
iCalTime = (Year(dt) * 10000 + Month(dt) * 100 + Day(dt) ) _
& "T"
& (Hour(tm)*10000 + Minute(tm) * 100 + Second(tm))
....
%>
Okay?
"Old Pedant" wrote:
Quote:
Originally Posted by
<%
...
dt = RS("Appt_Date")
tm = RS("Appt_Time")
iCalTime = (Year(dt) * 10000 + Month(dt) * 100 + Day(dt) ) _
& "T"
& (Hour(tm)*10000 + Minute(tm) * 100 + Second(tm))
...
%>
Oops...missed the underline on the "T" line.
It should read:
& "T" _
Or you can jam all of that stuff onto a single line of code and get rid of
the underlines. I formatted it like that so it would show cleanly in most
newsreaders. And then blew it. <sigh/>
Thanks :) very much appreciated..
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 197,031 network members.
Top Community Contributors
|
