Sintaksis Harfiah Interval
Sintaks berikut digunakan untuk literal interval dalam ODBC.
interval-literal ::= INTERVAL [+|-] interval-string interval-qualifier
interval-string ::= quote { year-month-literal | day-time-literal } quote
year-month-literal ::= years-value | [years-value -] months-value
day-time-literal ::= day-time-interval | time-interval
day-time-interval ::= days-value [hours-value [:minutes-value[:seconds-value]]]
time-interval ::= hours-value [:minutes-value [:seconds-value ] ]
| nilai menit [:seconds-value ]
| nilai detik
nilai tahun ::= datetime-value
nilai bulan ::= datetime-value
days-value ::= datetime-value
hours-value ::= datetime-value
nilai menit ::= datetime-value
seconds-value ::= seconds-integer-value [.[detik-pecahan] ]
seconds-integer-value ::= unsigned-integer
seconds-fraction ::= unsigned-integer
datetime-value ::= unsigned-integer
interval-qualifier ::= start-field TO end-field | single-datetime-field
start-field ::= non-second-datetime-field [(interval-leading-field-prescision )]
bidang akhir ::= non-second-datetime-field | SECOND[(interval-fractional-seconds-prescision)]
single-datetime-field ::= non-second-datetime-field [(interval-leading-field-prescision)] | SECOND[(interval-leading-field-prescision [, (interval-fractional-seconds-prescision)]
datetime-field ::= non-second-datetime-field | KEDUA
non-second-datetime-field ::= YEAR | BULAN | HARI | JAM | MENIT
interval-fractional-seconds-prescision ::= unsigned-integer
interval-leading-field-prescision ::= unsigned-integer
kutipan ::= '
unsigned-integer ::= digit...
Saran dan Komentar
https://aka.ms/ContentUserFeedback.
Segera hadir: Sepanjang tahun 2024 kami akan menghentikan penggunaan GitHub Issues sebagai mekanisme umpan balik untuk konten dan menggantinya dengan sistem umpan balik baru. Untuk mengetahui informasi selengkapnya, lihat:Kirim dan lihat umpan balik untuk