Sponsored Content
Top Forums UNIX for Advanced & Expert Users How to get the Missing dates between two dates in the table? Post 302772422 by Yoda on Monday 25th of February 2013 12:07:27 PM
Old 02-25-2013
You can use ALL_OBJECTS to generate missing dates:
Code:
select to_char(to_date('01/02/2013','dd/mm/yyyy') - 1 + rownum, 'dd/mm/yyyy') from ALL_OBJECTS
where  to_date('01/02/2013','dd/mm/yyyy') - 1 + rownum <= to_date('06/02/2013','dd/mm/yyyy');
01/02/2013
02/02/2013
03/02/2013
04/02/2013
05/02/2013
06/02/2013

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

comparing 2 dates

hi , I have two variables both containg dates, x= `date` and y= `date' their format being -> Fri Nov 12 22:59:50 MST 2004 how do I compare which one is greater. ->Can dates be converted into integer and then compared? ( one lengthy way would be to compare the words one by... (7 Replies)
Discussion started by: k_oops9
7 Replies

2. Shell Programming and Scripting

Need script to generate all the dates in DDMMYY format between 2 dates

Hello friends, I am looking for a script or method that can display all the dates between any 2 given dates. Input: Date 1 290109 Date 2 010209 Output: 300109 310109 Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies

3. Programming

Dates in C

Hello, I am working on a program in C and need to read, write and manage Dates (YYY-MM-DD HH:MM). I have made my own version of a structure to store the date data and something else. Do you recommend me to use the time.h library? In such case, is it worthwhile to have an structure containing... (1 Reply)
Discussion started by: Ister
1 Replies

4. Programming

SQL: find if a set od dates falls in another set of dates

Don't know if it is important: Debian Linux / MySQL 5.1 I have a table: media_id int(8) group_id int(8) type_id int(8) expiration date start date cust_id int(8) num_runs int(8) preferred_time int(8) edit_date timestamp ON UPDATE CURRENT_TIMESTAMP id... (0 Replies)
Discussion started by: vertical98
0 Replies

5. Emergency UNIX and Linux Support

Replacing dates]] with (dates)]]

Hi guys, For my wiki site I need to fix 1400 pages that use the wrong date format, most pages (not all) use eg. 1988]] I need to change that to (1988)]] The date range goes back to 1400 so I guess I need to do the following ssh into my server, dump mysql database vi .sql dump search... (20 Replies)
Discussion started by: lawstudent
20 Replies

6. UNIX for Dummies Questions & Answers

How to write the dates between 2 dates into a file

Hi All, I am trying to print the dates that falls between 2 date variables into a file. Here is the example. $BUS_DATE =20120616 $SUB_DATE=20120613 Output to file abc.txt should be : 20120613,20120614,120120615,20120616 Can you pls help me accomplish this in LINUX. Thanks... (5 Replies)
Discussion started by: dsfreddie
5 Replies

7. Shell Programming and Scripting

Generating dates between two dates

HI, i have row like this HHH100037440313438961000201001012012073110220002 N in this i have 2 dates in pos 25-32 and 33-40 , so based upon the se two dates , i need to generated records between these two values so in the above record 20100101 and 20120731 need to genearte rows like this... (4 Replies)
Discussion started by: sathishsr
4 Replies

8. Shell Programming and Scripting

How to get dates between two dates?

HI, to my shell script i pass two parameters date1 and date2 is there any way to get all dates betwen these two dates? if i pass 20130714 and 20130717 i need to get below dates 20130715 20130716 is it possible. thanks (3 Replies)
Discussion started by: ulab
3 Replies

9. Shell Programming and Scripting

Identifying missing file dates

Hi Experts, I have written the below script to check the missing files based on the date in the file name from current date to in a given interval of days. In the file names we have dates along with some name. ex:jera_sit_2017-04-25-150325.txt. The below script is working fine if we have only... (10 Replies)
Discussion started by: nalu
10 Replies

10. Shell Programming and Scripting

Display dates between two dates

Hi All, I have 2 dates in mm/dd format. sdate=10/01 (October 01) edate=10/10 (October 10) I need the dates in between these 2 dates like below. 10/01 10/02 10/03 10/04 10/05 10/06 10/07 10/08 (1 Reply)
Discussion started by: jayadanabalan
1 Replies
DATEFMT_FORMAT(3)							 1							 DATEFMT_FORMAT(3)

IntlDateFormatter::format - Format the date/time value as a string

	Object oriented style

SYNOPSIS
public string IntlDateFormatter::format (mixed $value) DESCRIPTION
Procedural style string datefmt_format (IntlDateFormatter $fmt, mixed $value) Formats the time value as a string. PARAMETERS
o $fmt - The date formatter resource. o $value - Value to format. This may be a DateTime object, an IntlCalendar object, a numeric type representing a (possibly fractional) num- ber of seconds since epoch or an array in the format output by localtime(3). If a DateTime or an IntlCalendar object is passed, its timezone is not considered. The object will be formatted using the formaters configured timezone. If one wants to use the timezone of the object to be formatted, IntlDateFormatter.setTimeZone(3) must be called before with the objects timezone. Alterna- tively, the static function datefmt_formatObject(3) may be used instead. RETURN VALUES
The formatted string or, if an error occurred, FALSE. CHANGELOG
+-----------------+---------------------------------------------------+ | Version | | | | | | | Description | | | | +-----------------+---------------------------------------------------+ |5.5.0/PECL 3.0.0 | | | | | | | Support for providing IntlCalendar objects to | | | the $value parameter was added. | | | | | 5.3.4 | | | | | | | Support for providing DateTime objects to the | | | $value parameter was added. | | | | +-----------------+---------------------------------------------------+ EXAMPLES
Example #1 datefmt_format(3) example <?php $fmt = datefmt_create( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'First Formatted output is ' . datefmt_format($fmt, 0); $fmt = datefmt_create( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'Second Formatted output is ' . datefmt_format($fmt, 0); $fmt = datefmt_create( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'First Formatted output with pattern is ' . datefmt_format($fmt, 0); $fmt = datefmt_create( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo "Second Formatted output with pattern is " . datefmt_format($fmt, 0); ?> Example #2 OO example <?php $fmt = new IntlDateFormatter( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'First Formatted output is ' . $fmt->format(0); $fmt = new IntlDateFormatter( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN ); echo 'Second Formatted output is ' . $fmt->format(0); $fmt = new IntlDateFormatter( 'en_US', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'First Formatted output with pattern is ' . $fmt->format(0); $fmt = new IntlDateFormatter( 'de-DE', IntlDateFormatter::FULL, IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'Second Formatted output with pattern is ' . $fmt->format(0); ?> The above example will output: First Formatted output is Wednesday, December 31, 1969 4:00:00 PM PT Second Formatted output is Mittwoch, 31. Dezember 1969 16:00 Uhr GMT-08:00 First Formatted output with pattern is 12/31/1969 Second Formatted output with pattern is 12/31/1969 Example #3 With IntlCalendar object <?php $tz = reset(iterator_to_array(IntlTimeZone::createEnumeration('FR'))); $formatter = IntlDateFormatter::create( 'fr_FR', IntlDateFormatter::FULL, IntlDateFormatter::FULL, $tz, IntlDateFormatter::GREGORIAN ); $cal = IntlCalendar::createInstance($tz, '@calendar=islamic-civil'); $cal->set(IntlCalendar::FIELD_MONTH, 8); //9th month, Ramadan $cal->set(IntlCalendar::FIELD_DAY_OF_MONTH, 1); //1st day $cal->clear(IntlCalendar::FIELD_HOUR_OF_DAY); $cal->clear(IntlCalendar::FIELD_MINUTE); $cal->clear(IntlCalendar::FIELD_SECOND); $cal->clear(IntlCalendar::FIELD_MILLISECOND); echo "In this islamic year, Ramadan started/will start on: ", $formatter->format($cal), " "; //Its the formatters timezone that is used: $formatter->setTimeZone('Asia/Tokyo'); echo "After changing timezone: ", $formatter->format($cal), " "; The above example will output: In this islamic year, Ramadan started/will start on: mardi 9 juillet 2013 19:00:00 heure avancee d'Europe centrale After changing timezone: mercredi 10 juillet 2013 02:00:00 heure normale du Japon SEE ALSO
datefmt_create(3), datefmt_parse(3), datefmt_get_error_code(3), datefmt_get_error_message(3), datefmt_format_object(3). PHP Documentation Group DATEFMT_FORMAT(3)
All times are GMT -4. The time now is 10:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy