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...