资源描述:
《Sybase日期函数详解》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、Sybase日期函数详解SybasedatefunctionKeyword:SybasedatefunctionSybasedatefunctionDatefunctionGetdate()Getthecurrenttime,youcansetuptogetavarietyoftimeformatsDatepart(date,part,date)Aportionofthespecifiedtimeanddatewhentheminutesandseconds.DateDiff(datesection,date1,date2)Whatisthedifferenceint
2、imebetweenthespecifieddate1andthedate2?DateAdd(date,part,value,expression,date)Calculatesthespecifiedtime,plusthetimelengthspecifiedbytheexpressionTakeapartofthetimeSelectdatepart(YY,getdate0)——yearSelectdatepart(mm,getdate0)一一monthSelectdatepart(DD,getdate0)―daySelectdatepart(HH,getdat
3、e0)一一hourSelectdatepart(MI,getdate0)一minSelectdatepart(ss,getdate0)一一sec一whatdayoftheweek?Thecalculatedresultsto//+1,firstdaysbecauseofthecalculatedforaweekonSunday,Saturdaybecameseventhdaysaweek())一一weekdaySetdatefirst1Selectdatepart(weekday,getdateStringtimeSelectgetdate()-‘03/11/12’S
4、electconvert(char,getdate0,101)-'09/27/2003,Selectconvert(char,getdate0,102)-'2003.11.12'Selectconvert(char,getdate(),103)-'27/09/2003’(char),getdate(102)(convert)Selectrtrim(convertSelectconvert(char,getdate(),104)27.09.2003,Selectconvert(char,getdate(),105)-27-09-2003,Selectconvert(ch
5、ar,getdate(),106)--'27,Sep,2003,Select,convert(char,getdate(),107)—'Sep27,2003'Select,convert(char,getdate(),108)11:16:06’Selectconvert11:16:28:746AM,(char,getdate(),109)-—'Sep272003Select,convert(char,getdate(),110)09-27-2003’Select,convert(char,getdate(),111)2003/09/27,Select,convert(
6、char,getdate(),112)20030927,+(char,getdate),(108))-2003.11.1211:03:41’IntegertimeSelect,convert(int,convert(char(10),getdate())112)-20031112Select,datepart(HH,getdate()),*10000+datepart(MI,getdate()),*100+datepart(SS,getdate())-110646-timeformat〃YYYY・MM.DDIIII:MI:SS〃isconvertedto〃YYYYMM
7、DDHHMISS〃〃Declare,@a,datetime,@tmp,varchar(20),@tmpl,varchar(20)Select@a=convert(datetime,J2004.08.03,12:12:12')Select,@tmp二convert(char(10),@a,112)Select@tmpSelect@tmpl二convert(char(10)),datepart(hh,@a)*10000+datepart(mi,@a)*100+datepart(ss,@(a))select@tmplselect@tmp二@tmp+@tmp