09-01-2016
os : SunOS 5.10
shell: bash shell
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello,
I want to convert MM DD YYYY date format to MM-DD-YYYY format.
For exemple:
I have to convert Nov 28 2005 to 28-11-2005.
Thenks for youf help.
DAFI (2 Replies)
Discussion started by: dafidak
2 Replies
2. Shell Programming and Scripting
Hi everybody:
Could anybody tell me how I convert from a julian date, with shell comands, to gregorian.
Thanks in advance. (2 Replies)
Discussion started by: tonet
2 Replies
3. Shell Programming and Scripting
file1
E106,0,1/9/1993,0,E001,E003,A,45200,3766.667,21.730769
E108,0,2/3/1995,0,E001,E003,A,15000,1250,7.211538
E109,0,06-mar-07,0,E001,E001,A,78000,6500,37.5
E110,0,09-dec-2008,0,E001,E001,A,56000,4666.667,26.923077
E104,0,06/04/1994,0,E001,E003,A,95000,7916.667,45.673077... (14 Replies)
Discussion started by: charandevu
14 Replies
4. Shell Programming and Scripting
Hi,
Does anyone know (in KSH, CSH, SED or AWK), how to convert date text in a file from:
EX:
May232008
to:
05232008
Thanks, (3 Replies)
Discussion started by: jgrant746
3 Replies
5. Shell Programming and Scripting
Hi
I want to convert MAY 05 2005 01:15:00PM date format to 2005/05/05 01:15:00PM .
CAn somebody suggest me a code ,I am new to unix shell programming.
Thanks
Arif (21 Replies)
Discussion started by: mab_arif16
21 Replies
6. Shell Programming and Scripting
Hi,
I have the string YYYYMMDDHHMMSS like 20090801204150 and I need to convert it using the unix command date in the format:
date "Saturday, 1 August 2009 20:40:59"
All in one single Unix line if this is possible. What's the correct syntax?
Steve Hagi (6 Replies)
Discussion started by: hagimeno
6 Replies
7. Shell Programming and Scripting
Hi Gurus,
Need help in Conversion of date(2007-11-30) to Julian date(YYDDD)...
'+%J'
2007-11-30 to 'YYDDD'
Thanks (4 Replies)
Discussion started by: SeenuGuddu
4 Replies
8. UNIX for Dummies Questions & Answers
(string(8)) ((date("YYYYMMDD")) ((date("YYYY/MM/DD")) in.date_field_name)) (1 Reply)
Discussion started by: dr46014
1 Replies
9. Shell Programming and Scripting
Hi all,
I require to convert julian date to normal calander date in unix
for eg julian date=122
now i want corresponding calander date
----------------------------------------
gr8 if give very small command/script
and please explain the steps as well(imp)
Thanks
... (3 Replies)
Discussion started by: RahulJoshi
3 Replies
10. Shell Programming and Scripting
Trying to convert dates using a Perl Script but it has to accept formats like
3 letter month, day and year like Nov 02 2010 or 1/4/11 or 21 Feb 2011 and have it convert to something like October 20, 2011. Any ideas? (2 Replies)
Discussion started by: reduxeffect81
2 Replies
LEARN ABOUT SUSE
alter_conversion
ALTER
CONVERSION(7) SQL Commands ALTER CONVERSION(7)
NAME
ALTER CONVERSION - change the definition of a conversion
SYNOPSIS
ALTER CONVERSION name RENAME TO newname
ALTER CONVERSION name OWNER TO newowner
DESCRIPTION
ALTER CONVERSION changes the definition of a conversion.
You must own the conversion to use ALTER CONVERSION. To alter the owner, you must also be a direct or indirect member of the new owning
role, and that role must have CREATE privilege on the conversion's schema. (These restrictions enforce that altering the owner doesn't do
anything you couldn't do by dropping and recreating the conversion. However, a superuser can alter ownership of any conversion anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing conversion.
newname
The new name of the conversion.
newowner
The new owner of the conversion.
EXAMPLES
To rename the conversion iso_8859_1_to_utf8 to latin1_to_unicode:
ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;
To change the owner of the conversion iso_8859_1_to_utf8 to joe:
ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;
COMPATIBILITY
There is no ALTER CONVERSION statement in the SQL standard.
SEE ALSO
CREATE CONVERSION [create_conversion(7)], DROP CONVERSION [drop_conversion(7)]
SQL - Language Statements 2010-05-14 ALTER CONVERSION(7)