How to know if a date exists between two months?

Question

Navigation

#1 by (0 votes)

-1

How can I know in SQL Sysbase if "22-12-1994" is between September and December

sql sybase

asked by Sebastian Mateus Villegas 14.11.2017 в 21:33

source

1 answer

score 0 · Accepted Answer

0

 select  CASE WHEN MONTH(cast('19941222' as date)) BETWEEN 9 AND 12 THEN 'SI' ELSE 'NO' END as EstaEntreSeptiembreYDiciembre

answered by 15.11.2017 / 19:23

source