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)
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)
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)
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)
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 CENTOS
alter_conversion
ALTER CONVERSION(7) PostgreSQL 9.2.7 Documentation ALTER CONVERSION(7)NAME
ALTER_CONVERSION - change the definition of a conversion
SYNOPSIS
ALTER CONVERSION name RENAME TO new_name
ALTER CONVERSION name OWNER TO new_owner
ALTER CONVERSION name SET SCHEMA new_schema
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.
new_name
The new name of the conversion.
new_owner
The new owner of the conversion.
new_schema
The new schema for 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))
PostgreSQL 9.2.7 2014-02-17 ALTER CONVERSION(7)