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
gtkcookie(1)						      General Commands Manual						      gtkcookie(1)

NAME
gtkcookie - edit Netscape cookie file SYNOPSIS
gtkcookie [ Gtk options ] DESCRIPTION
Options gtkcookie supports the command flags common to all Gtk applications. There are no gtkcookie-specific flags. What happens at startup On startup, gtkcookie will try to find your Netscape cookie file by looking for ~/.netscape/cookies. If ~/.netscape/cookies is found, gtk- cookie will load the file and show it in a multi-column list. Opening a cookie file Regardless of whether gtkcookie finds your cookie file, or you have to open it manually, when you open the file, all of your Netscape cook- ies are displayed in whatever order Netscape wrote them into the file. Sorting a cookie file You can sort the cookies by any column by clicking on the heading for that column. Human-readable dates The final column is actually not stored in your cookie file, but is a translation of Netscape's native date field. Netscape stores the date as the number of seconds since 1 Jan 1970 (familiar to anyone who's spent any time on Unix), but gtkcookie translates those dates into human-readable expiry dates in the final column. Editing cookies To edit a cookie, double-click on the cookie, and a cookie edit dialogue will pop up. You'll notice that the date, in seconds since the epoch (the epoch is 1 Jan 1970), is not an editable field, whereas the human-readable date is. Follow the format presented in the edit dia- logue box, and as you edit the human-readable date, the expiry date in seconds since the epoch will update itself. Please note (as repeated in the bugs section below) that although dates later than 2038 are supposed to present problems, (you'll see the date in seconds since the epoch become -1) dates on or after 2036 seem to present problems. I'm still looking into this. Searching for text strings Under the Edit menu, select Find. Type in a string or substring that you wish to find, and press the Find button. If the string or sub- string is found anywhere in a cookie, that cookie will become selected, and the view will scroll to that cookie, if necessary. Pressing Find again will search for the next instance, or pop up a "not found" dialogue box if the string wasn't found. In its current version, gtk- cookie isn't yet smart enough to re-start a search from the top of the cookie list, so if you need to search from the top, hightlight the first cookie, and then do your search. Deleting cookies Right click on a cookie, and select "Delete" from the popup menu, or click on the cookie and press "Del" on your keyboard. Creating cookies Press the "Create Cookie" button. A cookie with dummy values will be added to the cookie list, and the "Edit Cookie" dialogue box will pop up so that you can edit the new cookie to your liking. Note that even if you press "Cancel" immediately after creating a new cookie, the new cookie, with its dummy values, will still be in the list. You'll have to delete the cookie manually. FILES
~/.netscape/cookies The Netscape cookie file in your home directory SEE ALSO
None NOTES
None AUTHOR
Manni Wood: mwood@sig.bsh.com or pq1036@110.net BUGS
1. The "Edit Cookie" dialogue has problems with on-the-fly conversion of human-readable dates to the number of seconds since the epoch for dates later than 2036. For some reason, despite the fact that the date is supposed to overflow in 2038, the C function strptime flubs up the conversion for dates larger than 1036. Unfortunately, this means that when you edit a cookie whose expiry date is after 2036, the edit dialogue box shows the number of seconds since the epoch as -1. There is currently no workaround to this problem, besides moving the date back 2 years. 2. Although the "find" feature is supposed to always highlight and scroll to any found item, sometimes, the item becomes highlighted, but is outside the current view. 3. The file open and save dialogues don't show directories beginning with a dot (such as .netscape!) but typing such directory names manu- ally will work. 4. Double-clicking in the scroll bar will pop up the "Edit Cookie" dialogue box for the currently highlighted cookie. 5. Editing the cookie file while Netscape is running is futile, because Netscape will re-write the cookie file when you exit Netscape, based on what's in its memory, not what's in the cookie file. A popup menu in my programme warns you of a running netscape... unless you're running Netscape 4.5. Netscape 4.5 doesn't seem to create the same lock file that earlier Netscapes used to. October 1998 gtkcookie(1)
All times are GMT -4. The time now is 12:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy