Home » Developer & Programmer » Forms » hh:mm:ss with date (winxp)
hh:mm:ss with date [message #344550] Sat, 30 August 2008 08:47 Go to next message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

hi,

i want to create calendar with time which contains hh:mm:ss?
i have calendar i want to add this service? any ideas.

regrads,
bb
Re: hh:mm:ss with date [message #344560 is a reply to message #344550] Sat, 30 August 2008 10:30 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wonder how would "your" calendar look like for September 2008, having not only dates, but time up to seconds.

Just in case you didn't understand the above sentence: I see no point in doing that.
Re: hh:mm:ss with date [message #344599 is a reply to message #344560] Sat, 30 August 2008 23:18 Go to previous messageGo to next message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

so i can i will do it. i need to set up time with date when client selects. how to create hh:mm:ss? any ideas please,

regards,
bb
Re: hh:mm:ss with date [message #344628 is a reply to message #344599] Sun, 31 August 2008 03:21 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Search this forum for CALENDER
Re: hh:mm:ss with date [message #344641 is a reply to message #344599] Sun, 31 August 2008 05:52 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
blueF wrote on Sun, 31 August 2008 06:18
so i can i will do it.
Please, do so.

Quote:
i need to set up time with date when client selects
What time? If user selects 15.09.2008, as a date, what time would you want to set up with this date? Will your calendar look like
01.09.2008 00:00:00
01.09.2008 00:00:01
01.09.2008 00:00:02
01.09.2008 00:00:03
...
01.09.2008 00:00:59
01.09.2008 00:01.00
01.09.2008 00:01:01
...
If that's so, I must admit that this is one of the weirdest ideas I've seen. If we suppose that a year has 365 days x 24 hours x 60 minutes x 60 seconds, your calendar will have 31.536.000 "rows". I hope your users will be happy scrolling through 31 million records to be able to select desired date and time value.

If that's the case, I'd rather let them MANUALLY enter both date and time. It would be much less time and resources consuming.
Re: hh:mm:ss with date [message #344853 is a reply to message #344641] Mon, 01 September 2008 07:30 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Hi Littlefoot,

While what you're suggesting doesn't make sense it's not what I thought of when I saw the OPs request.
A lot of DB tools have a calendar with a time component. I've attached a screenshot of the PLSQL Developer one.

./fa/4929/0/

BlueF - is this what you had in mind?
If so, what problems are you having?
If you've already got a working calendar adding time should be simple enough.
Just add fields at the bottom for hours/mins/seconds and allow the user to overtype them with the values they want - validating it to make sure it's a valid time.
Re: hh:mm:ss with date [message #344860 is a reply to message #344853] Mon, 01 September 2008 07:59 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, cookiemonster; nice screenshot! This makes sense.
Re: hh:mm:ss with date [message #344867 is a reply to message #344853] Mon, 01 September 2008 08:08 Go to previous message
blueF
Messages: 22
Registered: August 2008
Location: gulf
Junior Member

Thank you..yes that is what i need.
Previous Topic: Conditional exit on PRE_FORM Trigger
Next Topic: date display through global varibales
Goto Forum:
  


Current Time: Sat Dec 03 05:40:01 CST 2016

Total time taken to generate the page: 0.06218 seconds