Convert Between any Document Format – Unoconv

Convert Between any Document Format – Unoconv

UNOCONV(1)                                                                                          UNOCONV(1)

NAME
       unoconv - convert any document from and to any OpenOffice supported format

SYNOPSIS
       unoconv [options] file [file2 ..]

       unoconv --listener [--server SRV] [--port PRT] [--connections CON]

DESCRIPTION
       unoconv is a command line utility that can convert any file format that OpenOffice can import, to any
       file format that OpenOffice is capable of exporting.

       unoconv uses the OpenOffice’s UNO bindings for non-interactive conversion of documents and therefor
       needs an OpenOffice instance to communicate with. Therefore if it cannot find one, it will start its
       own instance for temporary usage. If desired, one can start a “listener” instance to use for subsequent
       connections or even for remote connections.

OPTIONS
       -c, --connection
              UNO connection string to be used by the client to connect to an OpenOffice instance, or used by
              the listener to make OpenOffice listen.

              Default connection string is "socket,host=localhost,port=2002;urp;StarOffice.ComponentContext"

       -d, --doctype
              Specify the OpenOffice document type of the backend format. Possible document types are:
              document, graphics, presentation, spreadsheet.

              Default document type is 'document'.

       -e, --export
              Set specific export filter options (related to the used OpenOffice filter).

              eg. for the PDF output filter one can specify: -e PageRange=1-2

       -f, --format
              Specify the output format for the document. You can get a list of possible output formats per
              document type by using the --show option.

              Default document type is 'pdf'.

       -i, --import
              Set specific import filters options (related to the used OpenOffice filter).

              eg. for some input filters one can specify: -i utf8

       -l, --listener
              Start unoconv as listener for unoconv clients to connect to.

       -o, --outputpath
              Directory to put converted documents.

       --pipe Use a pipe as an alternative connection mechanism to talk to OpenOffice.

       -p, --port
              Port to listen on (as listener) or to connect to (as client).

              Default port is '2002'.

       -s, --server
              Server (address) to listen on (as listener) or to connect to (as client).

              Default server is 'localhost'.

       --show List the possible output formats to be used with -f.

       --stdout
              Print converted output file to stdout.

       -t, --template
              Specify the template to use for importing styles from. This can be very useful if you have a
              corporate identity you have to apply to every document you distribute.

       -T, --timeout
              When unoconv starts its own listener, try to connect to it for an amount of seconds before
              giving up. Increasing this may help when you receive random errors caused by the listener not
              being ready to accept conversion jobs.

       -v, --verbose
              Be more and more and more verbose.

ARGUMENTS
       You can provide one or more files as arguments to convert each of them to the specified output format.

EXAMPLES
       You can use unoconv in standalone mode, this means that in absence of an OpenOffice listener, it will
       starts its own:

       unoconv -f pdf some-document.odt
       One can use unoconv as a listener (by default localhost:2002) to let other unoconv instances connect to
       it:

       unoconv --listener &
       unoconv -f pdf some-document.odt
       unoconv -f doc other-document.odt
       unoconv -f jpg some-image.png
       unoconv -f xsl some-spreadsheet.csv
       kill -15 %-
       This also works on a remote host:

       unoconv --listener --server 1.2.3.4 --port 4567
       and then connect another system to convert documents:

       unoconv --server 1.2.3.4 --port 4567

BUGS
       unoconv uses the UNO bindings to connect to OpenOffice, in absence of a usable socket, it will start
       its own OpenOffice instance with the correct parameters.

       Note
       Please see the TODO file for known bugs and future plans.

SEE ALSO
       convert(1), file(1), odt2txt

REFERENCES
       unoconv is very useful together with the following tools:

       Asciidoc
              [1]http://www.methods.co.nz/asciidoc/

       docbook2odf
              [2]http://open.comsultia.com/docbook2odf/ A list of possible import and export formats is
              available from:

       OpenOffice 2.1
              [3]http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1

       OpenOffice 3.0
              [4]http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_3_0

AUTHOR
       Written by Dag Wieers, <[5]dag@wieers.com>

RESOURCES
       Main web site: [6]http://dag.wieers.com/home-made/unoconv/

COPYING
       Copyright (C) 2007 Dag Wieers. Free use of this software is granted under the terms of the GNU General
       Public License (GPL).

AUTHOR
       Dag Wieers <dag@wieers.com>.

REFERENCES
       1. http://www.methods.co.nz/asciidoc/
          http://www.methods.co.nz/asciidoc/

       2. http://open.comsultia.com/docbook2odf/
          http://open.comsultia.com/docbook2odf/

       3. http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1
          http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_2_1

       4. http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_3_0
          http://wiki.services.openoffice.org/wiki/Framework/Article/Filter/FilterList_OOo_3_0

       5. dag@wieers.com
          mailto:dag@wieers.com

       6. http://dag.wieers.com/home-made/unoconv/
          http://dag.wieers.com/home-made/unoconv/

  0.4                                           20 october 2010                                     UNOCONV(1)

The floowing list of all file formats currently availabe:

jerry@jerry-P5Q-office:~$ unoconv --show
The following list of document formats are currently available:

  bib      - BibTeX [.bib]
  doc      - Microsoft Word 97/2000/XP [.doc]
  doc6     - Microsoft Word 6.0 [.doc]
  doc95    - Microsoft Word 95 [.doc]
  docbook  - DocBook [.xml]
  html     - HTML Document (OpenOffice.org Writer) [.html]
  odt      - ODF Text Document [.odt]
  ott      - Open Document Text [.ott]
  ooxml    - Microsoft Office Open XML [.xml]
  pdf      - Portable Document Format [.pdf]
  rtf      - Rich Text Format [.rtf]
  latex    - LaTeX 2e [.ltx]
  sdw      - StarWriter 5.0 [.sdw]
  sdw4     - StarWriter 4.0 [.sdw]
  sdw3     - StarWriter 3.0 [.sdw]
  stw      - Open Office.org 1.0 Text Document Template [.stw]
  sxw      - Open Office.org 1.0 Text Document [.sxw]
  text     - Text Encoded [.txt]
  mediawiki - MediaWiki [.txt]
  txt      - Text [.txt]
  uot      - Unified Office Format text [.uot]
  vor      - StarWriter 5.0 Template [.vor]
  vor4     - StarWriter 4.0 Template [.vor]
  vor3     - StarWriter 3.0 Template [.vor]
  xhtml    - XHTML Document [.html]

The following list of graphics formats are currently available:

  bmp      - Windows Bitmap [.bmp]
  emf      - Enhanced Metafile [.emf]
  eps      - Encapsulated PostScript [.eps]
  gif      - Graphics Interchange Format [.gif]
  html     - HTML Document (OpenOffice.org Draw) [.html]
  jpg      - Joint Photographic Experts Group [.jpg]
  met      - OS/2 Metafile [.met]
  odd      - OpenDocument Drawing [.odd]
  otg      - OpenDocument Drawing Template [.otg]
  pbm      - Portable Bitmap [.pbm]
  pct      - Mac Pict [.pct]
  pdf      - Portable Document Format [.pdf]
  pgm      - Portable Graymap [.pgm]
  png      - Portable Network Graphic [.png]
  ppm      - Portable Pixelmap [.ppm]
  ras      - Sun Raster Image [.ras]
  std      - OpenOffice.org 1.0 Drawing Template [.std]
  svg      - Scalable Vector Graphics [.svg]
  svm      - StarView Metafile [.svm]
  swf      - Macromedia Flash (SWF) [.swf]
  sxd      - OpenOffice.org 1.0 Drawing [.sxd]
  sxd3     - StarDraw 3.0 [.sxd]
  sxd5     - StarDraw 5.0 [.sxd]
  tiff     - Tagged Image File Format [.tiff]
  vor      - StarDraw 5.0 Template [.vor]
  vor3     - StarDraw 3.0 Template [.vor]
  wmf      - Windows Metafile [.wmf]
  xhtml    - XHTML [.xhtml]
  xpm      - X PixMap [.xpm]

The following list of presentation formats are currently available:

  bmp      - Windows Bitmap [.bmp]
  emf      - Enhanced Metafile [.emf]
  eps      - Encapsulated PostScript [.eps]
  gif      - Graphics Interchange Format [.gif]
  html     - HTML Document (OpenOffice.org Impress) [.html]
  jpg      - Joint Photographic Experts Group [.jpg]
  met      - OS/2 Metafile [.met]
  odg      - ODF Drawing (Impress) [.odg]
  odp      - ODF Presentation [.odp]
  otp      - ODF Presentation Template [.otp]
  pbm      - Portable Bitmap [.pbm]
  pct      - Mac Pict [.pct]
  pdf      - Portable Document Format [.pdf]
  pgm      - Portable Graymap [.pgm]
  png      - Portable Network Graphic [.png]
  pot      - Microsoft PowerPoint 97/2000/XP Template [.pot]
  ppm      - Portable Pixelmap [.ppm]
  ppt      - Microsoft PowerPoint 97/2000/XP [.ppt]
  pwp      - PlaceWare [.pwp]
  ras      - Sun Raster Image [.ras]
  sda      - StarDraw 5.0 (OpenOffice.org Impress) [.sda]
  sdd      - StarImpress 5.0 [.sdd]
  sdd3     - StarDraw 3.0 (OpenOffice.org Impress) [.sdd]
  sdd4     - StarImpress 4.0 [.sdd]
  sxd      - OpenOffice.org 1.0 Drawing (OpenOffice.org Impress) [.sxd]
  sti      - OpenOffice.org 1.0 Presentation Template [.sti]
  svg      - Scalable Vector Graphics [.svg]
  svm      - StarView Metafile [.svm]
  swf      - Macromedia Flash (SWF) [.swf]
  sxi      - OpenOffice.org 1.0 Presentation [.sxi]
  tiff     - Tagged Image File Format [.tiff]
  uop      - Unified Office Format presentation [.uop]
  vor      - StarImpress 5.0 Template [.vor]
  vor3     - StarDraw 3.0 Template (OpenOffice.org Impress) [.vor]
  vor4     - StarImpress 4.0 Template [.vor]
  vor5     - StarDraw 5.0 Template (OpenOffice.org Impress) [.vor]
  wmf      - Windows Metafile [.wmf]
  xhtml    - XHTML [.xml]
  xpm      - X PixMap [.xpm]

The following list of spreadsheet formats are currently available:

  csv      - Text CSV [.csv]
  dbf      - dBASE [.dbf]
  dif      - Data Interchange Format [.dif]
  html     - HTML Document (OpenOffice.org Calc) [.html]
  ods      - ODF Spreadsheet [.ods]
  ooxml    - Microsoft Excel 2003 XML [.xml]
  ots      - ODF Spreadsheet Template [.ots]
  pdf      - Portable Document Format [.pdf]
  sdc      - StarCalc 5.0 [.sdc]
  sdc4     - StarCalc 4.0 [.sdc]
  sdc3     - StarCalc 3.0 [.sdc]
  slk      - SYLK [.slk]
  stc      - OpenOffice.org 1.0 Spreadsheet Template [.stc]
  sxc      - OpenOffice.org 1.0 Spreadsheet [.sxc]
  uos      - Unified Office Format spreadsheet [.uos]
  vor3     - StarCalc 3.0 Template [.vor]
  vor4     - StarCalc 4.0 Template [.vor]
  vor      - StarCalc 5.0 Template [.vor]
  xhtml    - XHTML [.xhtml]
  xls      - Microsoft Excel 97/2000/XP [.xls]
  xls5     - Microsoft Excel 5.0 [.xls]
  xls95    - Microsoft Excel 95 [.xls]
  xlt      - Microsoft Excel 97/2000/XP Template [.xlt]
  xlt5     - Microsoft Excel 5.0 Template [.xlt]
  xlt95    - Microsoft Excel 95 Template [.xlt]
廣告

dos2unix package plain text file format convert utilities

Windows 和 *unix 平台之間文件檔案格式互轉工具「dos2unix」。

Ubuntu 安裝 dos2unix:

sudo apt-get install dos2unix

此套件提供 dos2unix、unix2dos、unix2mac、mac2unix 四個指令來應付不同平台間的文件格式轉換。

使用說明手冊:

dos2unix(1) 2011-10-19 dos2unix(1)

NAME
dos2unix - DOS/Mac to Unix and vice versa text file format converter

SYNOPSIS
dos2unix [options] [FILE ...] [-n INFILE OUTFILE ...]
unix2dos [options] [FILE ...] [-n INFILE OUTFILE ...]

DESCRIPTION
The Dos2unix package includes utilities "dos2unix" and "unix2dos" to convert plain text files in DOS
or Mac format to Unix format and vice versa.

In DOS/Windows text files a line break, also known as newline, is a combination of two characters: a
Carriage Return (CR) followed by a Line Feed (LF). In Unix text files a line break is a single
character: the Line Feed (LF). In Mac text files, prior to Mac OS X, a line break was single Carriage
Return (CR) character. Nowadays Mac OS uses Unix style (LF) line breaks.

Binary files are automatically skipped, unless conversion is forced.

Non-regular files, such as directories and FIFOs, are automatically skipped.

Symbolic links and their targets are by default kept untouched. Symbolic links can optionally be
replaced, or the output can be written to the symbolic link target. Symbolic links on Windows are not
supported. Windows symbolic links always replaced, keeping the targets unchanged.

Dos2unix was modelled after dos2unix under SunOS/Solaris and has similar conversion modes.

OPTIONS
-- Treat all following options as file names. Use this option if you want to convert files whose
names start with a dash. For instance to convert a file named "-foo", you can use this command:

dos2unix -- -foo

Or in new file mode:

dos2unix -n -- -foo out.txt

-ascii
Convert only line breaks. This is the default conversion mode.

-iso
Conversion between DOS and ISO-8859-1 character set. See also section CONVERSION MODES.

-1252
Use Windows code page 1252 (Western European).

-437
Use DOS code page 437 (US). This is the default code page used for ISO conversion.

-850
Use DOS code page 850 (Western European).

-860
Use DOS code page 860 (Portuguese).

-863
Use DOS code page 863 (French Canadian).

-865
Use DOS code page 865 (Nordic).

-7 Convert 8 bit characters to 7 bit space.

-c, --convmode CONVMODE
Set conversion mode. Where CONVMODE is one of: ascii, 7bit, iso, mac with ascii being the default.

-f, --force
Force conversion of binary files.

-h, --help
Display help and exit.

-k, --keepdate
Keep the date stamp of output file same as input file.

-L, --license
Display program's license.

-l, --newline
Add additional newline.

dos2unix: Only DOS line breaks are changed to two Unix line breaks. In Mac mode only Mac line
breaks are changed to two Unix line breaks.

unix2dos: Only Unix line breaks are changed to two DOS line breaks. In Mac mode Unix line breaks
are changed to two Mac line breaks.

-n, --newfile INFILE OUTFILE ...
New file mode. Convert file INFILE and write output to file OUTFILE. File names must be given in
pairs and wildcard names should not be used or you will lose your files.

-o, --oldfile FILE ...
Old file mode. Convert file FILE and overwrite output to it. The program default to run in this
mode. Wildcard names may be used.

-q, --quiet
Quiet mode. Suppress all warnings and messages. The return value is zero. Except when wrong
command-line options are used.

-s, --safe
Skip binary files (default).

-F, --follow-symlink
Follow symbolic links and convert the targets.

-R, --replace-symlink
Replace symbolic links with converted files (original target files remain unchanged).

-S, --skip-symlink
Keep symbolic links and targets unchanged (default).

-V, --version
Display version information and exit.

MAC MODE
In normal mode line breaks are converted from DOS to Unix and vice versa. Mac line breaks are not
converted.

In Mac mode line breaks are converted from Mac to Unix and vice versa. DOS line breaks are not
changed.

To run in Mac mode use the command-line option "-c mac" or use the commands "mac2unix" or "unix2mac".

CONVERSION MODES
Conversion modes ascii, 7bit, and iso are similar to those of dos2unix/unix2dos under SunOS/Solaris.

ascii
In mode "ascii" only line breaks are converted. This is the default conversion mode.

Although the name of this mode is ASCII, which is a 7 bit standard, the actual mode is 8 bit. Use
always this mode when converting Unicode UTF-8 files.

7bit
In this mode all 8 bit non-ASCII characters (with values from 128 to 255) are converted to a 7 bit
space.

iso Characters are converted between a DOS character set (code page) and ISO character set ISO-8859-1
(Latin-1) on Unix. DOS characters without ISO-8859-1 equivalent, for which conversion is not
possible, are converted to a dot. The same counts for ISO-8859-1 characters without DOS
counterpart.

When only option "-iso" is used dos2unix will try to determine the active code page. When this is
not possible dos2unix will use default code page CP437, which is mainly used in the USA. To force
a specific code page use options "-437" (US), "-850" (Western European), "-860" (Portuguese),
"-863" (French Canadian), or "-865" (Nordic). Windows code page CP1252 (Western European) is also
supported with option "-1252". For other code pages use dos2unix in combination with iconv(1).
Iconv can convert between a long list of character encodings.

Some examples:

Convert from DOS default code page to Unix Latin-1

dos2unix -iso -n in.txt out.txt

Convert from DOS CP850 to Unix Latin-1

dos2unix -850 -n in.txt out.txt

Convert from Windows CP1252 to Unix Latin-1

dos2unix -1252 -n in.txt out.txt

Convert from Windows CP1252 to Unix UTF-8 (Unicode)

iconv -f CP1252 -t UTF-8 in.txt | dos2unix &gt; out.txt

Convert from Windows UTF-16 (Unicode) to Unix UTF-8 (Unicode)

iconv -f UTF-16 -t UTF-8 in.txt | dos2unix &gt; out.txt

Convert from Unix Latin-1 to DOS default code page.

unix2dos -iso -n in.txt out.txt

Convert from Unix Latin-1 to DOS CP850

unix2dos -850 -n in.txt out.txt

Convert from Unix Latin-1 to Windows CP1252

unix2dos -1252 -n in.txt out.txt

Convert from Unix UTF-8 (Unicode) to Windows CP1252

unix2dos &lt; in.txt | iconv -f UTF-8 -t CP1252 &gt; out.txt

Convert from Unix UTF-8 (Unicode) to Windows UTF-16 (Unicode)

unix2dos &lt; in.txt | iconv -f UTF-8 -t UTF-16 &gt; out.txt

See also &lt;http://czyborra.com/charsets/codepages.html&gt; and
&lt;http://czyborra.com/charsets/iso8859.html&gt;.

UNICODE
There exist different Unicode encodings. On Unix/Linux Unicode files are mostly encoded in UTF-8
encoding. UTF-8 is ASCII compatible. UTF-8 files can have DOS, Unix or Mac line breaks. It is safe to
run dos2unix/unix2dos on UTF-8 encoded files. On Windows mostly UTF-16 encoding is used for Unicode
files. Dos2unix/unix2dos should not be run on UTF-16 files. UTF-16 files are automatically skipped,
because they are considered binary.

EXAMPLES
Read input from 'stdin' and write output to 'stdout'.

dos2unix
dos2unix -l -c mac

Convert and replace a.txt. Convert and replace b.txt.

dos2unix a.txt b.txt
dos2unix -o a.txt b.txt

Convert and replace a.txt in ascii conversion mode.

dos2unix a.txt

Convert and replace a.txt in ascii conversion mode. Convert and replace b.txt in 7bit conversion
mode.

dos2unix a.txt -c 7bit b.txt
dos2unix -c ascii a.txt -c 7bit b.txt
dos2unix -ascii a.txt -7 b.txt

Convert a.txt from Mac to Unix format.

dos2unix -c mac a.txt
mac2unix a.txt

Convert a.txt from Unix to Mac format.

unix2dos -c mac a.txt
unix2mac a.txt

Convert and replace a.txt while keeping original date stamp.

dos2unix -k a.txt
dos2unix -k -o a.txt

Convert a.txt and write to e.txt.

dos2unix -n a.txt e.txt

Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt.

dos2unix -k -n a.txt e.txt

Convert and replace a.txt. Convert b.txt and write to e.txt.

dos2unix a.txt -n b.txt e.txt
dos2unix -o a.txt -n b.txt e.txt

Convert c.txt and write to e.txt. Convert and replace a.txt. Convert and replace b.txt. Convert d.txt
and write to f.txt.

dos2unix -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt

LOCALIZATION
LANG
The primary language is selected with the environment variable LANG. The LANG variable consists
out of several parts. The first part is in small letters the language code. The second is optional
and is the country code in capital letters, preceded with an underscore. There is also an optional
third part: character encoding, preceded with a dot. A few examples for POSIX standard type
shells:

export LANG=nl Dutch
export LANG=nl_NL Dutch, The Netherlands
export LANG=nl_BE Dutch, Belgium
export LANG=es_ES Spanish, Spain
export LANG=es_MX Spanish, Mexico
export LANG=en_US.iso88591 English, USA, Latin-1 encoding
export LANG=en_GB.UTF-8 English, UK, UTF-8 encoding

For a complete list of language and country codes see the gettext manual:
http://www.gnu.org/software/gettext/manual/gettext.html#Language-Codes
&lt;http://www.gnu.org/software/gettext/manual/gettext.html#Language-Codes&gt;

On Unix systems you can use to command locale(1) to get locale specific information.

LANGUAGE
With the LANGUAGE environment variable you can specify a priority list of languages, separated by
colons. Dos2unix gives preference to LANGUAGE over LANG. For instance, first Dutch and then
German: "LANGUAGE=nl:de". You have to first enable localization, by setting LANG (or LC_ALL) to a
value other than "C", before you can use a language priority list through the LANGUAGE variable.
See also the gettext manual:
http://www.gnu.org/software/gettext/manual/gettext.html#The-LANGUAGE-variable
&lt;http://www.gnu.org/software/gettext/manual/gettext.html#The-LANGUAGE-variable&gt;

If you select a language which is not available you will get the standard English messages.

DOS2UNIX_LOCALEDIR
With the environment variable DOS2UNIX_LOCALEDIR the LOCALEDIR set during compilation can be
overruled. LOCALEDIR is used to find the language files. The GNU default value is
"/usr/local/share/locale". Option --version will display the LOCALEDIR that is used.

Example (POSIX shell):

export DOS2UNIX_LOCALEDIR=$HOME/share/locale

RETURN VALUE
On success, zero is returned. When a system error occurs the system error will be returned. For other
errors 1 is returned.

The return value is always zero in quiet mode, except when wrong command-line options are used.

STANDARDS
http://en.wikipedia.org/wiki/Text_file http://en.wikipedia.org/wiki/Carriage_return
http://en.wikipedia.org/wiki/Newline

AUTHORS
Benjamin Lin - &lt;blin@socs.uts.edu.au&gt; Bernd Johannes Wuebben (mac2unix mode) - &lt;wuebben@kde.org&gt;,
Christian Wurll (add extra newline) - &lt;wurll@ira.uka.de&gt;, Erwin Waterlander - &lt;waterlan@xs4all.nl&gt;
(Maintainer)

Project page: &lt;http://www.xs4all.nl/~waterlan/dos2unix.html&gt;

SourceForge page: &lt;http://sourceforge.net/projects/dos2unix/&gt;

Freshmeat: &lt;http://freshmeat.net/projects/dos2unix&gt;

SEE ALSO
file(1) iconv(1)

dos2unix 2011-04-26 dos2unix(1)

SQL 字串樣式轉換為日期格式 CAST 和 CONVERT

字串格式轉換為日期格式範例:

-- SQL Server string to date / datetime conversion - datetime string format sql server
-- MSSQL string to datetime conversion - convert char to date - convert varchar to date
-- Subtract 100 from style number (format) for yy instead yyyy (or ccyy with century)
SELECT convert(datetime, 'Oct 23 2012 11:01AM', 100) -- mon dd yyyy hh:mmAM (or PM)
SELECT convert(datetime, 'Oct 23 2012 11:01AM') -- 2012-10-23 11:01:00.000
 
-- Without century (yy) string date conversion - convert string to datetime function
SELECT convert(datetime, 'Oct 23 12 11:01AM', 0) -- mon dd yy hh:mmAM (or PM)
SELECT convert(datetime, 'Oct 23 12 11:01AM') -- 2012-10-23 11:01:00.000
 
-- Convert string to datetime sql - convert string to date sql - sql dates format
-- T-SQL convert string to datetime - SQL Server convert string to date
SELECT convert(datetime, '10/23/2016', 101) -- mm/dd/yyyy
SELECT convert(datetime, '2016.10.23', 102) -- yyyy.mm.dd ANSI date with century
SELECT convert(datetime, '23/10/2016', 103) -- dd/mm/yyyy
SELECT convert(datetime, '23.10.2016', 104) -- dd.mm.yyyy
SELECT convert(datetime, '23-10-2016', 105) -- dd-mm-yyyy
-- mon types are nondeterministic conversions, dependent on language setting
SELECT convert(datetime, '23 OCT 2016', 106) -- dd mon yyyy
SELECT convert(datetime, 'Oct 23, 2016', 107) -- mon dd, yyyy
-- 2016-10-23 00:00:00.000
SELECT convert(datetime, '20:10:44', 108) -- hh:mm:ss
-- 1900-01-01 20:10:44.000
 
-- mon dd yyyy hh:mm:ss:mmmAM (or PM) - sql time format - SQL Server datetime format
SELECT convert(datetime, 'Oct 23 2016 11:02:44:013AM', 109)
-- 2016-10-23 11:02:44.013
SELECT convert(datetime, '10-23-2016', 110) -- mm-dd-yyyy
SELECT convert(datetime, '2016/10/23', 111) -- yyyy/mm/dd
-- YYYYMMDD ISO date format works at any language setting - international standard
SELECT convert(datetime, '20161023')
SELECT convert(datetime, '20161023', 112) -- ISO yyyymmdd
-- 2016-10-23 00:00:00.000
SELECT convert(datetime, '23 Oct 2016 11:02:07:577', 113) -- dd mon yyyy hh:mm:ss:mmm
-- 2016-10-23 11:02:07.577
SELECT convert(datetime, '20:10:25:300', 114) -- hh:mm:ss:mmm(24h)
-- 1900-01-01 20:10:25.300
SELECT convert(datetime, '2016-10-23 20:44:11', 120) -- yyyy-mm-dd hh:mm:ss(24h)
-- 2016-10-23 20:44:11.000
SELECT convert(datetime, '2016-10-23 20:44:11.500', 121) -- yyyy-mm-dd hh:mm:ss.mmm
-- 2016-10-23 20:44:11.500
 
-- Style 126 is ISO 8601 format: international standard - works with any language setting
SELECT convert(datetime, '2008-10-23T18:52:47.513', 126) -- yyyy-mm-ddThh:mm:ss(.mmm)
-- 2008-10-23 18:52:47.513
SELECT convert(datetime, N'23 شوال 1429  6:52:47:513PM', 130) -- Islamic/Hijri date
SELECT convert(datetime, '23/10/1429  6:52:47:513PM',    131) -- Islamic/Hijri date
 
-- Convert DDMMYYYY format to datetime - sql server to date / datetime
SELECT convert(datetime, STUFF(STUFF('31012016',3,0,'-'),6,0,'-'), 105)
-- 2016-01-31 00:00:00.000
-- SQL Server T-SQL string to datetime conversion without century - some exceptions
-- nondeterministic means language setting dependent such as Mar/Mär/mars/márc
SELECT convert(datetime, 'Oct 23 16 11:02:44AM') -- Default
SELECT convert(datetime, '10/23/16', 1) -- mm/dd/yy U.S.
SELECT convert(datetime, '16.10.23', 2) -- yy.mm.dd ANSI
SELECT convert(datetime, '23/10/16', 3) -- dd/mm/yy UK/FR
SELECT convert(datetime, '23.10.16', 4) -- dd.mm.yy German
SELECT convert(datetime, '23-10-16', 5) -- dd-mm-yy Italian
SELECT convert(datetime, '23 OCT 16', 6) -- dd mon yy non-det.
SELECT convert(datetime, 'Oct 23, 16', 7) -- mon dd, yy non-det.
SELECT convert(datetime, '20:10:44', 8) -- hh:mm:ss
SELECT convert(datetime, 'Oct 23 16 11:02:44:013AM', 9) -- Default with msec
SELECT convert(datetime, '10-23-16', 10) -- mm-dd-yy U.S.
SELECT convert(datetime, '16/10/23', 11) -- yy/mm/dd Japan
SELECT convert(datetime, '161023', 12) -- yymmdd ISO
SELECT convert(datetime, '23 Oct 16 11:02:07:577', 13) -- dd mon yy hh:mm:ss:mmm EU dflt
SELECT convert(datetime, '20:10:25:300', 14) -- hh:mm:ss:mmm(24h)
SELECT convert(datetime, '2016-10-23 20:44:11',20) -- yyyy-mm-dd hh:mm:ss(24h) ODBC can.
SELECT convert(datetime, '2016-10-23 20:44:11.500', 21)-- yyyy-mm-dd hh:mm:ss.mmm ODBC
------------

-- SQL Datetime Data Type: Combine date & time string into datetime - sql hh mm ss
-- String to datetime - mssql datetime - sql convert date - sql concatenate string
DECLARE @DateTimeValue varchar(32), @DateValue char(8), @TimeValue char(6)
 
SELECT @DateValue = '20120718',
       @TimeValue = '211920'
SELECT @DateTimeValue =
convert(varchar, convert(datetime, @DateValue), 111)
+ ' ' + substring(@TimeValue, 1, 2)
+ ':' + substring(@TimeValue, 3, 2)
+ ':' + substring(@TimeValue, 5, 2)
SELECT
DateInput = @DateValue, TimeInput = @TimeValue,
DateTimeOutput = @DateTimeValue;
/*
DateInput   TimeInput   DateTimeOutput
20120718    211920      2012/07/18 21:19:20 */

資料來源:http://www.sqlusa.com/bestpractices/datetimeconversion/
http://technet.microsoft.com/zh-tw/library/ms187928.aspx

Linux 光碟映像檔 轉檔工具

mdf2iso
mdf2iso converts an Alcohol 120% .mdf image to other CD image formats. It is able to write out plain .iso, .cue &
.bin and .toc & .dat. If you do not specifiy –cue or –toc, an .iso file gets generated. If you do not specifiy a
destination image name, BASENAME.ext is automatically used.

iat
iat (Iso9660 Analyzer Tool) is a tool for detecting the structure of many types of CD-ROM image file formats,
such as BIN, MDF, PDI, CDI, NRG, and B5I, and converting them into ISO-9660.

If output file name is not defined, then STDOUT will be used instead.