..the apex plugin directory

an initiative of

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Item Plugin Date and Hour Picker

Date and Hour Picker

Categories: Item Plugin
Author: Josep

Two separate HTML fields to input Date and Hour

Description: This plugin allows user to select date and time in two separate HTML fields. APEX developer retrieves only one field with resulting concatenated values. To use this plugin, create an item (of type plugin) and select the "Relational: Date and hour picker" plugin. Relevant parameters:

  • Standard "HTML Form Element Attributes": Adds attributes to Date field
  • Timestamp Format (Required): Format of Hour field
  • Default Timestamp Value (Required): Default value to be selected when item has no session value
  • Date Format (Required): Format of Date field
  • Date Default Value (Required): Default value to be selected when item has no session value
  • Timestamp NAMED LOV: In case you want the Hour field to be a select list, introduce here the APEX NAMED LOV.
  • Timestamp HTML attributes: Additional HTML tags for Hour field
  • Datepicker JS Attributes: Redefinition of standard datepicker apex.widget.datepicker call. See field info for an example.

Plugin renders a hidden HTML input element, with item provided name, and the resulting date and timestamp selected by user.

Two display fields are rendered with names <ITEM_NAME>_DATE, and <ITEM_NAME>_HOUR which can be used to associate Dyamic Actions via triggering.


-- Revisions:

1.0 = Initial Release

1.1 = Added Validations 

1.2 = Corrected JS bugs on APEX 4.2 

Special Requirements
Just create a new item!

Datepicker, date, hour, LOV, jquery, relational, josep coves, josep, coves, apex, timestamp, format, time

Date picker with Hour LOV
Date picker with Hour LOV
Company: Relational
Date added: 8.8.2012
Views: 10672
Votes: 0
Reviews: 6
Min. APEX Version:
Share on Facebook
Digg! Share on Digg
Save This Page
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
by Josep
on September 16, 2014
Hi Mankikandan, I haven't tested it for mobile, but as long as Javascript libraries are the same should work. Please check your mobile theme calls proper Javascript libraries or modify plugin code in order to point new libraries.
cannot able to insert mobile app
by Manikandan.S
on September 12, 2014
I am using oracle apex 4.2 i am choosing data picker and also format data and time but browser can support and insert perfectly but mobile can not support error occurred like format can not able to change.
Date format
by Anil
on July 23, 2014
When I change the date format from dd/mm/yyyy to
mm/dd/yyyy then the lov does not appear and the plug in does not work properly
Master detail form
by Fadil Maliqi
on July 30, 2013

Can this plugin be used on tabular form?
I'm having difficulties to implement it on tabular form.

September 13, 2012
The Entry has been updated in the meantime!
by Josep
on August 20, 2012
Hi Josip,

I've modified source, and catched format exceptions. When an invalid date mask i set, item displays no value but inner APEX item contains session value. With this solution you could add an internal validation to check correct format. I also added an example on my demo page with first item.

Hope that helps!
August 20, 2012
The Entry has been updated in the meantime!
by Josip Poljak
on August 20, 2012
Looks great, only if you could set some kind of inline validations. Now, if you insert an invalid date (or time) an error page displays (not so user friendly).

Best regards,
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.