Database Anniversary Dates: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) (→Cargo) |
||
| Line 5: | Line 5: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=CollectionLocation | tables=CollectionLocation | ||
|fields=_pageName=unit, StartDate=start, EndDate=end, | |fields=_pageName=unit, | ||
DATEDIFF(EndDate,StartDate)= | StartDate=start, | ||
CONCAT(" | EndDate=end, | ||
DATEDIFF(COALESCE(EndDate, CURRENT_DATE()),StartDate)=days, | |||
CONCAT("{{age{{!}}EndDate=",COALESCE(EndDate, CURRENT_DATE()),"{{!}}StartDate=",StartDate,"}}")=years | |||
|order by=unit | |order by=unit | ||
|limit= | |limit=100 | ||
|default=no results were found | |default=no results were found | ||
}} | }} | ||
Revision as of 23:10, 2020 March 29
Anniversary dates for:
Cargo
| unit | start | end | days | years |
|---|---|---|---|---|
| CON MICU | 1999-05-01 | 2019-06-23 | 7358 | 20 years |
| GH-2S | 2020-04-14 | 2020-06-18 | 65 | 0 years |
| GH-5S C | 2020-04-07 | 2020-04-10 | 3 | 0 years |
| GH-CC | 2020-10-15 | 1282 | 3 years | |
| GH-EMIP | 2010-11-01 | 2020-10-01 | 3622 | 9 years |
| GH-Med | 2020-10-01 | 1296 | 3 years | |
| GH-MICU | 1998-09-14 | 9349 | 25 years | |
| GH-N3 | 2005-01-01 | 7048 | 19 years | |
| GH-N5 | 2005-01-01 | 7048 | 19 years | |
| GH-OVER | 2007-05-09 | 2007-05-09 | 0 | 0 years |
| GH-Recovery Room | 2020-04-01 | 1479 | 4 years | |
| GH-S3 | 2015-05-26 | 3251 | 8 years | |
| GH-W3 | 2005-01-01 | 2016-05-26 | 4163 | 11 years |
| HSC A4 | 2003-10-01 | 7506 | 20 years | |
| HSC B2 | 2020-04-07 | 2020-08-07 | 122 | 0 years |
| HSC B3 | 2004-10-18 | 7123 | 19 years | |
| HSC CCU | 1999-05-01 | 2019-06-17 | 7352 | 20 years |
| HSC D4 | 2004-03-01 | 2020-03-20 | 5863 | 16 years |
| HSC D4 COVID | 2020-04-03 | 2020-05-14 | 41 | 0 years |
| HSC D5 | 2020-03-19 | 2020-05-28 | 70 | 0 years |
| HSC D5 D | 2020-03-19 | 2020-05-28 | 70 | 0 years |
| HSC D5 Pre COVID | 2004-03-01 | 2020-03-19 | 5862 | 16 years |
| HSC EMIP | 2016-10-01 | 2020-10-15 | 1475 | 4 years |
| HSC H4 | 2004-04-01 | 7323 | 20 years | |
| HSC H4H | 2005-05-01 | 2020-04-14 | 5462 | 14 years |
| HSC HOBS | 2020-08-07 | 1351 | 3 years | |
| HSC IICU | 1997-05-13 | 9838 | 26 years | |
| HSC Med | 2020-10-15 | 1282 | 3 years | |
| HSC MICU | 1988-07-11 | 13066 | 35 years | |
| HSC SICU | 1988-07-11 | 13066 | 35 years | |
| HSC WRS2 | August 2023 | 248 | 0 years | |
| HSC WRS3 | 2020-03-19 | 1492 | 4 years | |
| HSC-GA7S | 2004-10-18 | 7123 | 19 years | |
| OAK MICU | 1999-06-01 | 2019-09-20 | 7416 | 20 years |
| STB A7 B | March 2020 | 2020-06-11 | 102 | 0 years |
| STB ACCU | 2016-07-05 | 2845 | 7 years | |
| STB B4 | 2004-11-01 | 2009-11-17 | 1842 | 5 years |
| STB B5 | 2009-11-18 | 5266 | 14 years | |
| STB B5old | 2004-08-01 | 2009-10-13 | 1899 | 5 years |
| STB CCU | 1999-05-24 | 2016-07-05 | 6252 | 17 years |
| STB CICU | 2007-01-15 | 6304 | 17 years | |
| STB E5 | 2004-12-01 | 7079 | 19 years | |
| STB E6 B | 2004-10-14 | 7127 | 19 years | |
| STB E6 C | March 2024 | 2020-06-11 | -1377 | -4 years |
| STB EMIP | 2016-03-07 | 2020-10-15 | 1683 | 4 years |
| STB IMCU | 2018-10-01 | 2019-04-01 | 182 | 0 years |
| STB Med | 2020-10-15 | 1282 | 3 years | |
| STB MICU | 1999-05-24 | 9097 | 24 years | |
| STB SICU | 1999-05-24 | 2007-01-15 | 2793 | 7 years |
| VIC EMIP | 2007-02-01 | 2017-09-30 | 3894 | 10 years |
| VIC MICU | 1999-06-01 | 2017-09-25 | 6691 | 18 years |
| VIC N3F | 2005-07-01 | 2006-06-30 | 364 | 0 years |
| VIC N4 | 2017-09-29 | 2018-01-12 | 105 | 0 years |
| VIC N4C | 2017-10-02 | 2018-10-26 | 389 | 1 years |
| VIC N5 | 2005-08-01 | 2017-10-01 | 4444 | 12 years |
| VIC N5C | 2017-10-03 | 2018-10-26 | 388 | 1 years |
| VIC S3 | 2005-10-01 | 2017-09-22 | 4374 | 11 years |
| VIC S4 | 2005-10-01 | 2017-10-01 | 4383 | 12 years |
| VIC S5 | 2005-09-01 | 2017-09-30 | 4412 | 12 years |
| VIC S5C | 2017-10-03 | 2018-10-26 | 388 | 1 years |
- GRA EMIP - 13yrs (2010-11-01)
old
- GRA MICU - 25yrs (1998-09-14)
- GRA N3 - 19yrs (2005-01-01)
- GRA N5 - 19yrs (2005-01-01)
- GRA OVER - 16yrs (2007-05-09)
- GRA W3 - 19yrs (2005-01-01)
- HSC A4 - 20yrs (2003-10-01)
- HSC B3 - 19yrs (2004-10-18)
- HSC CCU - 24yrs (1999-05-01)
- HSC D4 - 20yrs (2004-03-01)
- HSC WRS3 - 4yrs (2020-03-19)
- HSC D5 - 4yrs (2020-03-19)
- HSC H4 - 20yrs (2004-04-01)
- HSC H4H - 18yrs (2005-05-01)
- HSC IICU - 26yrs (1997-05-13)
- HSC MICU - 35yrs (1988-07-11)
- HSC SICU - 35yrs (1988-07-11)
- HSC EMIP - 7yrs (2016-10-01)
- STB B5old - 19yrs (2004-08-01)
- STB B4 - 19yrs (2004-11-01)
- STB B5 - 14yrs (2009-11-18)
- STB CCU - 24yrs (1999-05-24)
- STB CICU - 17yrs (2007-01-15)
- STB E5 - 19yrs (2004-12-01)
- STB E6 B - 19yrs (2004-10-14)
- STB MICU - 24yrs (1999-05-24)
- STB SICU - 24yrs (1999-05-24)
- STB EMIP - 8yrs (2016-03-07)
Ended
- VIC MICU - 18 yrs 3 mths - (1999-Jun-01 to 2017-Sep 25)
- VIC N3F- 1 year - (2005-Jul-01 to 2006-Jun-30)
- VIC N4 - 3.5 mths - (2017-Sep-29 to 2018-Jan-12)
- VIC N5 - 12 yrs 2 mths - (2005-Aug-01 to 2017-Oct-01)
- VIC S3 - 12 yrs - (2005-Oct-01 to 2017-Sep-22)
- VIC S4 - 12 yrs - (2005-Oct-01 to 2017-Oct-01)
- VIC EMIP - 17yrs (2007-02-01)
- VIC S5 - 18yrs (2005-09-01)
- VIC N5C - 1 yr - (2017-Oct-02 to 2018-Oct-27))
- VIC S5C - 1 yr - (2017-Oct-02 to 2018-Oct-27))
- VIC N4C - 1 yr - (2017-Oct-02 to 2018-Oct-27))
Related articles
| Related articles: |