Sponsored Content
Operating Systems AIX How to manipulate date format? Post 302534073 by ruby on Monday 27th of June 2011 12:20:53 AM
Old 06-27-2011
How to manipulate date format?

Hi,

I need to convert the below string in 'yyyymmdd' format.

e.g.,

24 June 2011 -> 20110624

Please help !!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to manipulate date?

Hi can u pls help me out with this as i am relatively new to unix. I need to use 4 different types of dates in my shell script * first day of the last(previous) month * last day of the last(previous) month * first day of the current month * (sysdate-1) yesterday's date for the current... (5 Replies)
Discussion started by: phani
5 Replies

2. Shell Programming and Scripting

convert mmddyy date format to ccyyddd format??

hi, for reading a cobol indexed file i need to convert "mmddyy" date format to "ccyyddd" format. i checked the datecalc and other scripts but couldnt modify them to cater to my need:(... The datecalc gives an output which i believe is the total days till that date, but i want to convert it... (2 Replies)
Discussion started by: Bhups
2 Replies

3. Shell Programming and Scripting

manipulate data with specific format

Hi everybody: I have a problem with how I have to manipulate the data which have specific format like this: 249. 0.30727021E+05 0.30601627E+05 0.37470780E-01 -0.44745335E+02 0.82674536E+03 248. 0.30428182E+05 0.30302787E+05 0.40564921E-01 -0.45210293E+02 ... (5 Replies)
Discussion started by: tonet
5 Replies

4. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

5. Shell Programming and Scripting

manipulate & format the output of spool command

Hi All, I am spooling the data some sql queries into a single file but wanted to know how to format the data of the file generated by spool. #!/bin/sh unset -f USAGE USAGE () { clear echo "############################USAGE#######################\n" echo "Incorrect number of... (2 Replies)
Discussion started by: ss_ss
2 Replies

6. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e... (2 Replies)
Discussion started by: figaro
2 Replies

7. Shell Programming and Scripting

finding date numeral from file and check the validity of date format

hi there I have file names in different format as below triss_20111117_fxcb.csv triss_fxcb_20111117.csv xpnl_hypo_reu_miplvdone_11172011.csv xpnl_hypo_reu_miplvdone_11-17-2011.csv xpnl_hypo_reu_miplvdone_20111117.csv xpnl_hypo_reu_miplvdone_20111117xfb.csv... (10 Replies)
Discussion started by: manas_ranjan
10 Replies

8. Solaris

How to Manipulate Date based on number of days?

I have script where in i issue a command to get back 6 month earlier date. below command works on all linux distribution. # date +%Y-%m-%d --date="2012-03-31 - 183 days ago" 2011-09-30 Is there any solaris equivalent command to do the same? (1 Reply)
Discussion started by: pinga123
1 Replies

9. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

Hi Unix Gurus, I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies

10. Shell Programming and Scripting

Date: invalid date trying to set Linux date in specific format

i try to set linux date & time in specific format but it keep giving me error Example : date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" or date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" keep giving me this error : date: invalid date ‘19-01-2017 00:05:01' Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies
DATEFMT_SET_PATTERN(3)							 1						    DATEFMT_SET_PATTERN(3)

IntlDateFormatter::setPattern - Set the pattern used for the IntlDateFormatter

	Object oriented style

SYNOPSIS
public bool IntlDateFormatter::setPattern (string $pattern) DESCRIPTION
Procedural style bool datefmt_set_pattern (IntlDateFormatter $fmt, string $pattern) Set the pattern used for the IntlDateFormatter. PARAMETERS
o $fmt - The formatter resource. o $pattern - New pattern string to use. Possible patterns are documented at http://userguide.icu-project.org/formatparse/datetime. RETURN VALUES
Returns TRUE on success or FALSE on failure. Bad formatstrings are usually the cause of the failure. EXAMPLES
Example #1 datefmt_set_pattern(3) example <?php $fmt = datefmt_create( 'en_US', IntlDateFormatter::FULL,IntlDateFormatter::FULL, 'America/Los_Angeles', IntlDateFormatter::GREGORIAN, 'MM/dd/yyyy' ); echo 'pattern of the formatter is : ' . datefmt_get_pattern($fmt); echo 'First Formatted output with pattern is ' . datefmt_format($fmt, 0); datefmt_set_pattern($fmt, 'yyyymmdd hh:mm:ss z'); echo 'Now pattern of the formatter is : ' . datefmt_get_pattern($fmt); 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, 'MM/dd/yyyy' ); echo 'pattern of the formatter is : ' . $fmt->getPattern(); echo 'First Formatted output is ' . $fmt->format(0); $fmt->setPattern('yyyymmdd hh:mm:ss z'); echo 'Now pattern of the formatter is : ' . $fmt->getPattern(); echo 'Second Formatted output is ' . $fmt->format(0); ?> The above example will output: pattern of the formatter is : MM/dd/yyyy First Formatted output with pattern is 12/31/1969 Now pattern of the formatter is : yyyymmdd hh:mm:ss z Second Formatted output with pattern is 19690031 04:00:00 PST SEE ALSO
datefmt_get_pattern(3), datefmt_create(3). PHP Documentation Group DATEFMT_SET_PATTERN(3)
All times are GMT -4. The time now is 12:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy