05-21-2013
Can you provide a breakup of the last date and time field...
10 More Discussions You Might Find Interesting
1. Programming
hi all,
could anyone help me?
I need to query output by compare dates from 2 table and i'm using a UNION query..and wanted to sort the output by date..
My query like this:
SELECT
TO_CHAR(DATE) DATE1,
INVOICE
FROM ACCOUNT1
WHERE DATE < (to_date('122003','MMYYYY'))
UNION ... (2 Replies)
Discussion started by: kate katherine
2 Replies
2. Shell Programming and Scripting
Hi,
I'm using the below command to sort and remove duplicates in a file. But, i need to make this applied to the same file instead of directing it to another.
Thanks (6 Replies)
Discussion started by: dvah
6 Replies
3. Shell Programming and Scripting
Hi all,
I have 2 files containing data like this:
so if there is same entry repeated in the column like1,2,3,4
I have to check if there is different entries column like 2,4
but similar entries for duplicatein column 2 like1,3
the output shuld be like this for first file
... (5 Replies)
Discussion started by: manigrover
5 Replies
4. Shell Programming and Scripting
Hi Experts ,
we have a CDC file where we need to get the latest record of the Key columns
Key Columns will be CDC_FLAG and SRC_PMTN_I
and fetch the latest record from the CDC_PRCS_TS
Can we do it with a single awk command.
Please help.... (3 Replies)
Discussion started by: vijaykodukula
3 Replies
5. Shell Programming and Scripting
Hi,
I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates.
NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Discussion started by: samrat dutta
2 Replies
6. Shell Programming and Scripting
I need to use bash to remove duplicates without using sort first.
I can not use:
cat file | sort | uniq
But when I use only
cat file | uniq
some duplicates are not removed. (4 Replies)
Discussion started by: locoroco
4 Replies
7. Shell Programming and Scripting
Hi,
i "tried" to sort data by date. So far, i used sed to take the data from the last and the actual month. Now, after changing the year it is not working properly.
i use:
GNU bash, version 4.2.45(1)-release (x86_64-suse-linux-gnu)
sed -n '/\//p' $Home/../scripte/pd_0.txt
y is a... (6 Replies)
Discussion started by: IMPe
6 Replies
8. Shell Programming and Scripting
Here is my task :
I need to sort two input files and remove duplicates in the output files :
Sort by 13 characters from 97 Ascending
Sort by 1 characters from 96 Ascending
If duplicates are found retain the first value in the file
the input files are variable length, convert... (4 Replies)
Discussion started by: ysvsr1
4 Replies
9. UNIX for Beginners Questions & Answers
I have /tmp dir with filename as:
010020001_S-FOR-Sort-SYEXC_20160229_2212101.marker
010020001_S-FOR-Sort-SYEXC_20160229_2212102.marker
010020001-S-XOR-Sort-SYEXC_20160229_2212104.marker
010020001-S-XOR-Sort-SYEXC_20160229_2212105.marker
010020001_S-ZOR-Sort-SYEXC_20160229_2212106.marker... (4 Replies)
Discussion started by: gnnsprapa
4 Replies
10. Shell Programming and Scripting
Following is the input. 1st and 3rd block are same(block starts here with '*' and ends before blank line) , 2nd and 4th blocks are also the same:
cat <file>
* Wed Feb 24 2016 Tariq Saeed <tariq.x.saeed@mail.com> 2.0.7-1.0.7
- add vmcore dump support for ocfs2
* Mon Jun 8 2015 Brian Maly... (4 Replies)
Discussion started by: Paras Pandey
4 Replies
sttime(3) ShapeTools Toolkit Library sttime(3)
NAME
stMktime, stWriteTime - date and time handling
SYNOPSIS
#include <config.h>
#include <sttk.h.h>
time_tstMktime (char *string);
char*stWriteTime (time_t date);
DESCRIPTION
stMktime scans the given string and tries to read a date and time from it. It understands various formats of date strings. The following is
a list of all valid formats, optional parts in brackets.
[Tue] Jan 5[,] [19]93
This includes the standard asctime(3) format.
Jan 5 With no year given, the year defaults to the current year.
[19]93/01/05 This notation requires month and day represented by exactly two digits.
5.1.[19]93 This is the usual German notation.
5.1. German notation referencing the current year.
A certain time, given together with the date must always have the following form.
hours:minutes[:seconds]
Each of the fields must be an integer value within the proper range (hours: 0-23, minutes and seconds: 0-59). Values below
10 may be written as one digit numbers.
The time value may be placed anywhere in the date string: at the beginning, at the end, or somewhere in the middle. Any amount of white-
space may be given between a field of the time value and the separating colon. The time is always considered to be local time.
stWriteTime generates a time string similar to asctime(3) from its date argument.
SEE ALSO
asctime(3)
BUGS
Time Zone Names within the time string (like `MET') are not handled properly. In most cases they will cause a failure.
sttk-1.7 Thu Jun 24 17:43:35 1993 sttime(3)