java£¬php£¬mysqlʱ¼ä´¦Àí
javaÖÐʱ¼ä´ÁºÍʱ¼ä×Ö·û´®Ö®¼äµÄת»»
»ñÈ¡µ±Ç°µÄunixʱ¼ä´Á
new Date().getTime()
System.currentTimeMillis()
·µ»ØµÄÊǺÁÃëÊý£¬Òª×ª»»long t = System.currentTimeMillis()/1000;
»ñÈ¡µ±Ç°ÄêÔÂÈÕÒÔ¼°Ê±·ÖÃë
Calendar c = Calendar.getInstance();
c.get(Calendar.YEAR)) c.get(Calendar.YEAR)) c.get(Calendar.DATE)
½«UNIXʱ¼ä´Áת»»³Éʱ¼ä×Ö·û´®
new SimpleDateFormat("yyyy/MM/dd").format(new Date(timestamp*1000));
½«Ê±¼ä×Ö·û´®×ª»»³ÉUNIXʱ¼ä´Á
new java.text.SimpleDateFormat (”dd/MM/yyyy HH:mm:ss”).parse(”09/22/2008 16:33:00″).getTime()
ÔÚjavaÖÐ×Ö·û´®ºÍunixʱ¼ä´ÁÖ®¼äÓÐÒ»¸öÖÐרÀàÐÍÊÇDate
Date.getTime() ÓÉDateµ½unixtime
new Date(unixtime) ÓÉunixtimeµ½Date
×¢Ò⣺
Çë×¢Ò⣡¶ÔÓ벻ͬµÄÊ±Çø´¦ÀíÉÏÓвîÒ죬Ê×ÏÈÒªÇå³þ×Ô¼ºËùÔÚµÄÊ±Çø¡£
String timezone_info = System.getProperty(”user.timezone”);
System.out.println(”µ±Ç°µÄÊ±Çø:”+timezone_info);
System.out.println(”Ê±ÇøÐÅÏ¢:”+TimeZone.getDefault());
Êä³ö£º
µ±Ç°µÄÊ±Çø:Asia/Shanghai
Ê±ÇøÐÅÏ¢:sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,
dstSavings=0,useDaylight=false,transitions=19,lastRule=null]
´¦Àí²»Í¬µÄÊ±ÇøµÄ·½·¨£º
SimpleDateFormat sd = new SimpleDateFormat(”yyyy-MM-dd HH:mm:ss”);
sd.setTimeZone(TimeZone.getTimeZone(”GMT+8″));
String strDate = sd.format(new Date(1215782027390L));
System.out.println(”Õý°ËÇøµ±Ç°Ê±¼ä:”+strDate);
Êä³ö£º
Õý°ËÇøµ±Ç°Ê±¼ä:2008-07-11 21:13:47
phpÖÐʱ¼ä´ÁºÍʱ¼ä×Ö·û´®Ö®¼äµÄת»»
mktime()
date("format", unixtime)
time()
date('Y')
mysqlÖÐʱ¼ä´ÁºÍʱ¼ä×Ö·û´®Ö®¼äµÄת»»
°Ñʱ¼ä×Ö·û´®×ªÎªunixʱ¼ä´Á£¨¸ñʽҪYYYY-mm-dd hh:ii:ss) ¼´Êý¾Ý¿âÖÐtimestampÉú³ÉµÄ
UNIX_TIMESTAMP(date)
°Ñunixʱ¼ä´ÁתΪʱ¼ä×Ö·û´®
DATE_FORMAT(date,format)
»ñÈ¡µ±Ç°Ê±¼ä£¨unixʱ¼ä´Á£©
now
¸ù¾Ýformat×Ö·û´®¸ñʽ»¯dateÖµ¡£
%M ÔÂÃû×Ö(January……December)
%W ÐÇÆÚÃû×Ö(Sunday……Saturday)
%D ÓÐÓ¢Óïǰ׺µÄÔ·ݵÄÈÕÆÚ(1st, 2nd, 3rd, µÈµÈ¡££©
%Y Äê, Êý×Ö,
Ïà¹ØÎĵµ£º
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]
¸ÃÓï¾äÄÜ´´½¨ÐµÄÊÓͼ£¬Èç¹û¸ø¶¨ÁËOR REPLACE×Ӿ䣬¸ÃÓï¾ä»¹ÄÜÌæ»»ÒÑÓеÄÊÓͼ¡£select_st ......
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º
mysql> SELECT something from table
WHERE TO_DAYS(NOW())&nbs ......
ÓÐÁ½ÖÖ·½·¨¡£
·½·¨Ò»£ºÔÚmysql>Ìáʾ·ûÖÐʹÓÃtee
mysql> tee output.txt
Logging to file 'output.txt'
mysql> notee
Outfile disabled.
»òÕß
mysql> \T output.txt
Logging to file 'output.txt'
mysql> \t
Outfile disabled.
Õâ¸öÀàËÆÓÚsqlplusµÄspool¹¦ÄÜ£¬¿ÉÒÔ½«ÃüÁîÐÐÖеĽá¹û±£´æµ½Í ......
Êýѧº¯Êý
Abs
º¯ÊýÃèÊö£ºmixed abs(mixed number);
·µ»ØÖµ£ºº¯Êýabs·µ»Ø²ÎÊýnumberµÄ¾ø¶ÔÖµ¡£
Acos
º¯ÊýÃèÊö£ºdouble acos(double number);
·µ»ØÖµ£ºº¯Êýacos·µ»Ø²ÎÊýnumberµÄ·´ÓàÏÒÖµ¡£Èç¹û²ÎÊýnumber´óÓÚ1»òСÓÚ1£¬
ÔòÆä·´ÓàÏÒÖµÎÞÒâÒå ¡£
Acosh --
·´Ë«ÇúÓàÏÒ
Asin
º¯ÊýÃèÊö£»double asin(double number); ......
/*
* ¹¦ÄÜ£ºPHP
ͼƬˮӡ (ˮӡ֧³ÖͼƬ»òÎÄ×Ö)
* ²ÎÊý£º
* $product_img ±³¾°Í¼Æ¬£¬¼´ÐèÒª¼ÓˮӡµÄͼƬ£¬ÔÝÖ»Ö§³ÖGIF,JPG,PNG¸ñʽ£»
* $waterPos ˮӡλÖã¬ÓÐ10ÖÖ״̬£¬0ÎªËæ»úλÖã»
* &n ......