NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit8fe55ef

Thomas G. Lockhart

committed

Support special values 'now', 'current', etc on output.

1 parentf54cc39 commit8fe55efCopy full SHA for 8fe55ef

File tree

1 file changed

+25

-23

lines changed

src/backend/utils/adt
- timestamp.c

1 file changed

+25

-23

lines changed

`‎src/backend/utils/adt/timestamp.c‎`

Lines changed: 25 additions & 23 deletions

Original file line number	Diff line number	Diff line change
`@@ -29,13 +29,33 @@ timestamp_out(time_t timestamp)`
`29`	`29`	`charzone[MAXDATELEN+1],`
`30`	`30`	`*tzn=zone;`
`31`	`31`
`32`		`-abstime2tm(timestamp,&tz,tm,tzn);`
`33`		`-EncodeDateTime(tm,fsec,&tz,&tzn,USE_ISO_DATES,buf);`
`34`		`-`
	`32`	`+switch (timestamp)`
	`33`	`+{`
	`34`	`+caseEPOCH_ABSTIME:`
	`35`	`+strcpy(buf,EPOCH);`
	`36`	`+break;`
	`37`	`+caseINVALID_ABSTIME:`
	`38`	`+strcpy(buf,INVALID);`
	`39`	`+break;`
	`40`	`+caseCURRENT_ABSTIME:`
	`41`	`+strcpy(buf,DCURRENT);`
	`42`	`+break;`
	`43`	`+caseNOEND_ABSTIME:`
	`44`	`+strcpy(buf,LATE);`
	`45`	`+break;`
	`46`	`+caseNOSTART_ABSTIME:`
	`47`	`+strcpy(buf,EARLY);`
	`48`	`+break;`
	`49`	`+default:`
	`50`	`+abstime2tm(timestamp,&tz,tm,tzn);`
	`51`	`+EncodeDateTime(tm,fsec,&tz,&tzn,USE_ISO_DATES,buf);`
	`52`	`+break;`
	`53`	`+}`
	`54`	`+`
`35`	`55`	`result=palloc(strlen(buf)+1);`
`36`	`56`	`strcpy(result,buf);`
`37`	`57`	`returnresult;`
`38`		`-}`
	`58`	`+}/* timestamp_out() */`
`39`	`59`
`40`	`60`	`time_t`
`41`	`61`	`now(void)`
`@@ -49,58 +69,40 @@ now(void)`
`49`	`69`	`bool`
`50`	`70`	`timestampeq(time_tt1,time_tt2)`
`51`	`71`	`{`
`52`		`-#ifFALSE`
`53`		`-return(t1==t2);`
`54`		`-#endif`
`55`	`72`	`return(abstimeeq(t1,t2));`
`56`	`73`	`}`
`57`	`74`
`58`	`75`	`bool`
`59`	`76`	`timestampne(time_tt1,time_tt2)`
`60`	`77`	`{`
`61`		`-#ifFALSE`
`62`		`-return(t1!=t2);`
`63`		`-#endif`
`64`	`78`	`return(abstimene(t1,t2));`
`65`	`79`	`}`
`66`	`80`
`67`	`81`	`bool`
`68`	`82`	`timestamplt(time_tt1,time_tt2)`
`69`	`83`	`{`
`70`		`-#ifFALSE`
`71`		`-return(t1>t2);`
`72`		`-#endif`
`73`	`84`	`return(abstimelt(t1,t2));`
`74`	`85`	`}`
`75`	`86`
`76`	`87`	`bool`
`77`	`88`	`timestampgt(time_tt1,time_tt2)`
`78`	`89`	`{`
`79`		`-#ifFALSE`
`80`		`-return(t1<t2);`
`81`		`-#endif`
`82`	`90`	`return(abstimegt(t1,t2));`
`83`	`91`	`}`
`84`	`92`
`85`	`93`	`bool`
`86`	`94`	`timestample(time_tt1,time_tt2)`
`87`	`95`	`{`
`88`		`-#ifFALSE`
`89`		`-return(t1 >=t2);`
`90`		`-#endif`
`91`	`96`	`return(abstimele(t1,t2));`
`92`	`97`	`}`
`93`	`98`
`94`	`99`	`bool`
`95`	`100`	`timestampge(time_tt1,time_tt2)`
`96`	`101`	`{`
`97`		`-#ifFALSE`
`98`		`-return(t1 <=t2);`
`99`		`-#endif`
`100`	`102`	`return(abstimege(t1,t2));`
`101`	`103`	`}`
`102`	`104`
`103`		`-DateTime*`
	`105`	`+DateTime*`
`104`	`106`	`timestamp_datetime(time_ttimestamp)`
`105`	`107`	`{`
`106`	`108`	`DateTime*result;`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit8fe55ef

File tree

1 file changed

1 file changed

`‎src/backend/utils/adt/timestamp.c‎`

0 commit comments