結果値 - Advanced SQL Engine - Teradata Database
Teradata Vantage™ - SQLの日付/時刻関数と式
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.05
- 17.00
- Published
- 2020年6月
- Language
- 日本語
- Last Update
- 2021-03-30
- dita:mapPath
- ja-JP/xmd1556127764262.ditamap
- dita:ditavalPath
- ja-JP/xmd1556127764262.ditaval
- dita:id
- B035-1211
- Product Category
- Software
- Teradata Vantage
| EID |
Name |
Dept No |
JobSt1 |
JobEnd1 |
JobSt2 |
JobEnd2 |
|---|
| 1 |
Tom |
101 |
DATE'2001-01-01' |
DATE'2004-01-01' |
DATE'2005-01-01' |
DATE'2006-01-01' |
| 2 |
Rick |
201 |
DATE'2005-01-01' |
DATE'2006-01-01' |
DATE'2001-01-01' |
DATE'2004-01-01' |
| 3 |
Joo |
301 |
DATE'2005-01-01' |
DATE'2006-01-01' |
DATE'2006-01-01' |
DATE'2007-01-01' |
| 4 |
Tam |
401 |
DATE'2001-01-01' |
DATE'2006-01-01' |
DATE'2002-01-01' |
DATE'2004-01-01' |
| 5 |
Pat |
501 |
DATE'2005-01-01' |
DATE'2007-01-01' |
DATE'2006-01-01' |
DATE'2008-01-01' |
| 6 |
Jack |
601 |
DATE'2005-01-01' |
DATE'2007-01-01' |
DATE'2007-01-01' |
DATE'2008-01-01' |
| 7 |
Yu |
701 |
DATE'2005-01-01' |
DATE'2007-01-01' |
DATE'2004-01-01' |
DATE'2005-01-01' |
| 8 |
Tim |
801 |
DATE'2005-01-01' |
DATE'2007-01-01' |
DATE'2005-01-01' |
DATE'2007-01-01' |