Sponsored Content
Top Forums UNIX for Dummies Questions & Answers converting 6 digit column to dates format Post 85415 by Gerry405 on Wednesday 5th of October 2005 10:03:56 AM
Old 10-05-2005
dates

Hi thanks for those, but none of them seem to work on my flavour DataGeneral unix

monsanbu

From the first script I get lots of the following:
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number

VINO
I don't seem to have the "-d" option, so I have dumped an extract from the man pages below to hopefully help in solving

SYNOPSIS
touch [ -amc ] [-r ref_file | -t time] files
touch [ -amc ] [ mmddhhmm[yy] ] files

DESCRIPTION
Touch updates the access and modification times of each argument. If no time is specified the current time is used.
(See date(1) for a description of the second synopsis' time format.)

Options are:

-a Update only the access time.

-m Update only the modification time.

If neither -a nor -m is specified, the effect is the same as
-am.

-c Silently prevent touch from creating the file if it did not
previously exist.

-r ref_file
Use the corresponding time of ref_file instead of the current
time.

-t time Use time instead of the current time. time is a decimal
number of the form:
[[CC]YY]MMDDhhmm[.SS]

where each two digits represent the following:
MM month of the year (01-12)
DD day of the month (01-31)
hh hour of the day (00-23)
mm minute of the hour (00-59)
CC first two digits of the year (the century)
YY second two digits of the year
SS second of the minute (0-61)

CC and YY are optional. If neither is given, the current
year is assumed. If YY is specified, but CC is not, CC is
derived as follows:
If YY is: CC becomes:
------------------------
69-99 19
00-68 20

The range for SS is (00-61), because of leap seconds. If SS
is 60 or 61 and the resulting time, as affected by the TZ
environment variable, does not refer to a leap second; the
resulting time shall be one or two seconds after a time where
SS is 59. If SS is not given it is assumed to be zero.

DIAGNOSTICS
The following exit values are returned:

0 The utility executed successfully and all requested changes
were made.

>0 An error occurred.

SEE ALSO
date(1).
utime(2)

NOTESe--
The -t time option should be used in preference to the second
synopsis usage, since the second synopsis may not be supported in
future releases.

Last edited by Gerry405; 10-05-2005 at 11:09 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Format dates

I have a date that is received as text in Jan 1 2002 12:00AM format. Can anyone give me any ideas how to format that in oracle format i.e. 01-JAN-02 (1 Reply)
Discussion started by: jinky
1 Replies

2. UNIX for Advanced & Expert Users

Select entries between two dates by converting Unix timestamp in Oracle Database.

Hi, I need to select the entries between two dates from an Oracle db. The Oracle db has a column with Unix timestamps. I use the following querry, but it doesnt seem to be working as desired. select count(*) from reporter_status where to_char(FIRSTOCCURRENCE, 'mm-dd-yy') between ('08-07-06')... (1 Reply)
Discussion started by: amitsayshii
1 Replies

3. 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

4. Shell Programming and Scripting

Split large file based on last digit from a column

Hello, What's the best way to split a large into multiple files based on the last digit in the first column. input file: f 2738483300000x0y03772748378831x1y13478378358383x2y23743878383802x3y33787828282820x4y43748838383881x5y5 Desired Output: f0 3738483300000x0y03787828282820x4y4 f1... (9 Replies)
Discussion started by: alain.kazan
9 Replies

5. Shell Programming and Scripting

Dates not comparing correct even the same format

I have the date of the file passed into a variable also current date formatted same passed into a separate variable and compare the two with an if statement and statement always comes up false. Even though I verified the dates. Any help would be awesome. Filecrtdate=`ls -l $i | awk '{print... (19 Replies)
Discussion started by: coderanger
19 Replies

6. Shell Programming and Scripting

Converting windows format file to unix format using script

Hi, I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix. My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies

7. Shell Programming and Scripting

command for converting 4 column data to 1 column

dear friends I want to convert four column data to one column data. For example: from 1, 2, 3, 4 5, 6, 7, 8to 1 2 3 4 5 6 7 8what is the general command for that type of convertion. thanks (5 Replies)
Discussion started by: rpf
5 Replies

8. UNIX for Dummies Questions & Answers

Converting column to rows for every 3 lines in the column

Hi gurus! Please help me with this one. I have an file with the following contents: a b c d e f g h i j I would like to make to transform it to look like this as my output file: a,b,c d,e,f (4 Replies)
Discussion started by: kokoro
4 Replies

9. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies

10. UNIX for Dummies Questions & Answers

Converting dates to iso format

Hi , i am trying to read a tsv file record by record and change the date column with iso date format. it have different dates with format like mm/dd/yyyy HH:MM:SS EST ,i am trying serarch for the date format lke this yyyy-mm-dd HH:MM:SS EST and replace to it if dosent match that format . Any... (2 Replies)
Discussion started by: vikatakavi
2 Replies
TOUCH(1)						    BSD General Commands Manual 						  TOUCH(1)

NAME
touch -- change file access and modification times SYNOPSIS
touch [-acfhm] [-r file] [-t [[CC]YY]MMDDhhmm[.SS]] file ... DESCRIPTION
The touch utility sets the modification and access times of files to the current time of day. If the file doesn't exist, it is created with default permissions. The following options are available: -a Change the access time of the file. The modification time of the file is not changed unless the -m flag is also specified. -c Do not create the file if it does not exist. The touch utility does not treat this as an error. No error messages are displayed and the exit value is not affected. -f This flag has no effect; it is accepted for compatibility reasons. -h If file is a symbolic link, access and/or modification time of the link is changed. This option implies -c. -m Change the modification time of the file. The access time of the file is not changed unless the -a flag is also specified. -r Use the access and modifications times from the specified file instead of the current time of day. -t Change the access and modification times to the specified time. The argument should be in the form ``[[CC]YY]MMDDhhmm[.SS]'' where each pair of letters represents the following: CC The first two digits of the year (the century). YY The second two digits of the year. If ``YY'' is specified, but ``CC'' is not, a value for ``YY'' between 69 and 99 results in a ``CC'' value of 19. Otherwise, a ``CC'' value of 20 is used. MM The month of the year, from 1 to 12. DD The day of the month, from 1 to 31. hh The hour of the day, from 0 to 23. mm The minute of the hour, from 0 to 59. SS The second of the minute, from 0 to 61. If the ``CC'' and ``YY'' letter pairs are not specified, the values default to the current year. If the ``SS'' letter pair is not specified, the value defaults to 0. The touch utility exits 0 on success, and >0 if an error occurs. COMPATIBILITY
The obsolescent form of touch, where a time format is specified as the first argument, is supported. When no -r or -t option is specified, there are at least two arguments, and the first argument is a string of digits either eight or ten characters in length, the first argument is interpreted as a time specification of the form ``MMDDhhmm[YY]''. The ``MM'', ``DD'', ``hh'' and ``mm'' letter pairs are treated as their counterparts specified to the -t option. If the ``YY'' letter pair is in the range 69 to 99, the year is set to 1969 to 1999, otherwise, the year is set in the 21st century. SEE ALSO
utimes(2) STANDARDS
The touch utility is expected to be a superset of the IEEE Std 1003.2 (``POSIX.2'') specification. HISTORY
A touch utility appeared in Version 7 AT&T UNIX. BUGS
A symbolic link can't be a reference file of access and/or modification time. BSD
February 22, 2011 BSD
All times are GMT -4. The time now is 09:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy