{"Entry":{"collection":"func","key":"timestamp","name":"timestamp","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":true,"doc_overhaul":false,"from":"7.1","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"7.2"},{"descriptions_changed":false,"doc_overhaul":false,"from":"7.2","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"removed","to":"7.3"}],"content_hash":"9d7ca074abe7d675a6342f4ef6cde111254c40fd3f8ffb2401f2d6cfe2d591ac","first_version":"7.1","group":"datetime","group_label":"Date/Time Functions And Operators","groups":["datetime"],"imported_at":"2026-09-27T17:57:28.577542+08:00","last_version":"7.2","name":"timestamp","name_key":"timestamp","position":8028,"present_in":["7.1","7.2"],"signature":"timestamp ( date ) → timestamp","signature_count":2,"slug":"timestamp","source_rev":"b7bd9cda","summary":"date to timestamp","summary_zh":""}},"Definition":{"Collection":"func","Key":"timestamp","SourceDatabase":"center","Version":"7.2","SourceTable":"func","SourceKey":"timestamp","SourceRevision":"b7bd9cda","Facts":{"description":"date to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-DATETIME-TABLE","file":"functions-datetime.html","slug":"7.2"},"group":"datetime","group_label":"Date/Time Functions And Operators","lang":"en","layout":"table-old","pages":["functions-datetime.html"],"prose_only":false,"signatures":[{"description":"date to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","examples":[{"expr":"timestamp(date '2000-12-25')","result":"2000-12-25 00:00:00"}],"html":"\u003ccode class=\"function\"\u003etimestamp\u003c/code\u003e ( date ) → \u003ccode class=\"returnvalue\"\u003etimestamp\u003c/code\u003e","returns":"timestamp","text":"timestamp ( date ) → timestamp","zh_from":""},{"description":"date and time to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e and \u003ccode class=\"type\"\u003etime\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","examples":[{"expr":"timestamp(date '1998-02-24',time '23:07')","result":"1998-02-24 23:07:00"}],"html":"\u003ccode class=\"function\"\u003etimestamp\u003c/code\u003e ( date, time ) → \u003ccode class=\"returnvalue\"\u003etimestamp\u003c/code\u003e","returns":"timestamp","text":"timestamp ( date, time ) → timestamp","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-DATETIME-TABLE","file":"functions-datetime.html","slug":"7.2"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"timestamp","SourceDatabase":"center","Version":"7.2","Locale":"en","Title":"timestamp","Summary":"date to timestamp","BodyHTML":"\u003ccode\u003edate\u003c/code\u003e to \u003ccode\u003etimestamp\u003c/code\u003e","SourceRevision":"b7bd9cda","ContentHash":"b08696fd59d0e99b2912d88b541cb8b694fcaa7044e732a9d778531c4d54ccba","Payload":{"description":"date to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","signatures":[{"description":"date to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","examples":[{"expr":"timestamp(date '2000-12-25')","result":"2000-12-25 00:00:00"}],"html":"\u003ccode class=\"function\"\u003etimestamp\u003c/code\u003e ( date ) → \u003ccode class=\"returnvalue\"\u003etimestamp\u003c/code\u003e","returns":"timestamp","text":"timestamp ( date ) → timestamp","zh_from":""},{"description":"date and time to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e and \u003ccode class=\"type\"\u003etime\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","examples":[{"expr":"timestamp(date '1998-02-24',time '23:07')","result":"1998-02-24 23:07:00"}],"html":"\u003ccode class=\"function\"\u003etimestamp\u003c/code\u003e ( date, time ) → \u003ccode class=\"returnvalue\"\u003etimestamp\u003c/code\u003e","returns":"timestamp","text":"timestamp ( date, time ) → timestamp","zh_from":""}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["7.1","7.2"],"Locales":["en"],"Signatures":[{"Version":"7.2","Ordinal":0,"Hash":"dcd42627c92fbdc64010efedd283857359c698184eff2923f5da5a6e412371a8","Text":"timestamp ( date ) → timestamp","Returns":"timestamp","Payload":{"description":"date to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","examples":[{"expr":"timestamp(date '2000-12-25')","result":"2000-12-25 00:00:00"}],"html":"\u003ccode class=\"function\"\u003etimestamp\u003c/code\u003e ( date ) → \u003ccode class=\"returnvalue\"\u003etimestamp\u003c/code\u003e","returns":"timestamp","text":"timestamp ( date ) → timestamp","zh_from":""}},{"Version":"7.2","Ordinal":1,"Hash":"391276928ae9f3df4d3f4ce5e498fa48948b5464633dedd1962ec654d414d26a","Text":"timestamp ( date, time ) → timestamp","Returns":"timestamp","Payload":{"description":"date and time to timestamp","description_html":"\u003ccode class=\"type\"\u003edate\u003c/code\u003e and \u003ccode class=\"type\"\u003etime\u003c/code\u003e to \u003ccode class=\"type\"\u003etimestamp\u003c/code\u003e","description_zh":"","description_zh_html":"","examples":[{"expr":"timestamp(date '1998-02-24',time '23:07')","result":"1998-02-24 23:07:00"}],"html":"\u003ccode class=\"function\"\u003etimestamp\u003c/code\u003e ( date, time ) → \u003ccode class=\"returnvalue\"\u003etimestamp\u003c/code\u003e","returns":"timestamp","text":"timestamp ( date, time ) → timestamp","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}