HTML input 태그에서 type을 file 로 지정하여 파일을 업로드하고자 할 때, accept 인자를 통해서 확장자 필터링을 할 수 있다.

대부분의 확장자 필터링은 아래와 같은 코드로 필터링할 수 있다.

▶ CSV
<input type="file" accept=".csv" />

- 주의) 만약 엑셀 CSV 파일을 화면에 띄우고자 업로드할 경우, 아래와 같은 타입은 사용하면 안된다.

▶ Excel Files 2003-2007 (.xls)

<input type="file" accept="application/vnd.ms-excel" />

▶ Excel Files 2010 (.xlsx)

<input type="file" accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" />

▶ Text Files (.txt)

<input type="file" accept="text/plain" />

▶ Image Files (.png/.jpg/etc)

<input type="file" accept="image/*" />

▶ HTML Files (.htm,.html)

<input type="file" accept="text/html" />

▶ Video Files (.avi, .mpg, .mpeg, .mp4)

<input type="file" accept="video/*" />

▶ Audio Files (.mp3, .wav, etc)

<input type="file" accept="audio/*" />

▶ PDF Files

<input type="file" accept=".pdf" />

출처 : http://stackoverflow.com/questions/11832930/html-input-file-accept-attribute-file-type-csv

우선 아주 훌륭한 사이트를 소개한다.

http://www.epochconverter.com/

http://www.unixtimestamp.com/index.php

epochconverter.com 에서 각 언어별 예제를 상세하게 알아볼 수 있다.

더불어 epoch<->current time converter 까지 각 언어 별로 제공한다.

그 예시를 아래에 포스트한다.

How to get the current epoch time in ...

Convert from human readable date to epoch

PHP	strtotime("15 November 2012") (converts most English date texts) or: date_create('01/15/2010')->format('U') (PHP5 DateTime class) more ...
Python	import time first, then int(time.mktime(time.strptime('2000-01-01 12:34:00', '%Y-%m-%d %H:%M:%S'))) - time.timezone
Ruby	Time.local(year, month, day, hour, minute, second, usec ) (or Time.gm for GMT/UTC input). To display add .to_i
Perl	Use the Perl Epoch routines
Java	long epoch = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").parse("01/01/1970 01:00:00").getTime() / 1000;
VBScript/ASP	DateDiff("s", "01/01/1970 00:00:00", time field)
AutoIT	_DateDiff('s', "1970/01/01 00:00:00", "YYYY/MM/DD HH:MM:SS")
Delphi	Epoch := DateTimeToUnix(StrToDateTime(myString));
C	Use the C Epoch Converter routines
R	as.numeric(as.POSIXct("MM/dd/yyyy HH:mm:ss", origin="1970-01-01"))
MySQL	SELECT unix_timestamp(time) Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD More on using Epoch timestamps with MySQL
PostgreSQL	SELECT extract(epoch FROM date('2000-01-01 12:34')); With timestamp: SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-08'); With interval: SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
SQLite	SELECT strftime('%s',timestring);
SQL Server	SELECT DATEDIFF(s, '1970-01-01 00:00:00', time field)
JavaScript	Use the JavaScript Date object
Unix/Linux Shell	date +%s -d"Jan 1, 1980 00:00:01" Replace '-d' with '-ud' to input in GMT/UTC time.

Convert from epoch to human readable date

PHP	date(output format, epoch); Output format example: 'r' = RFC 2822 date more ...
Python	import time first, then time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.localtime(epoch)) Replace time.localtime with time.gmtime for GMT time.
Ruby	Time.at(epoch)
Perl	Use the Perl Epoch routines
Java	String date = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").format(new java.util.Date (epoch*1000));
VBScript/ASP	DateAdd("s", epoch, "01/01/1970 00:00:00")
AutoIT	_DateAdd("s", $EpochSeconds , "1970/01/01 00:00:00")
Delphi	myString := DateTimeToStr(UnixToDateTime(Epoch)); Where Epoch is a signed integer.
C	Use the C Epoch Converter routines
Objective-C	NSDate * myDate = [NSDate dateWithTimeIntervalSince1970:epoch]; NSLog(@"%@", date);
R	as.POSIXct(epoch, origin="1970-01-01", tz="GMT")
MySQL	FROM_UNIXTIME(epoch, optional output format) Default output format is YYY-MM-DD HH:MM:SS. If you need support for negative timestamps: DATE_FORMAT(DATE_ADD(FROM_UNIXTIME(0), interval -315619200 second),"%Y-%m-%d") (replace -315619200 with epoch) more ...
PostgreSQL	PostgreSQL version 8.1 and higher: SELECT to_timestamp(epoch); Older versions: SELECT TIMESTAMP WITH TIME ZONE 'epoch' + epoch * INTERVAL '1 second';
SQLite	SELECT datetime(epoch_to_convert, 'unixepoch'); or local timezone: SELECT datetime(epoch_to_convert, 'unixepoch', 'localtime');
Oracle PL/SQL	SELECT to_date('01-JAN-1970','dd-mon-yyyy')+(1326357743/60/60/24) from dual Replace 1326357743 with epoch.
SQL Server	DATEADD(s, epoch, '1970-01-01 00:00:00')
Microsoft Excel	=(A1 / 86400) + 25569 Format the result cell for date/time, the result will be in GMT time (A1 is the cell with the epoch number). For other time zones: =((A1 +/- time zone adjustment) / 86400) + 25569.
Crystal Reports	DateAdd("s", {EpochTimeStampField}-14400, #1/1/1970 00:00:00#) -14400 used for Eastern Standard Time. See Time Zones.
JavaScript	Use the JavaScript Date object
Tcl/Tk	clock format 1325376000
Unix/Linux Shell	date -d @1190000000 Replace 1190000000 with your epoch, needs recent version of 'date'. Replace '-d' with '-ud' for GMT/UTC time.
PowerShell	Function get-epochDate ($epochDate) { [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds($epochDate)) }, then use: get-epochDate 1279152364. Works for Windows PowerShell v1 and v2
Other OS's	Command line: perl -e "print scalar(localtime(epoch))" (If Perl is installed) Replace 'localtime' with 'gmtime' for GMT/UTC time.

U+AC00 to U+AD00