how i review twin datetime fields nonetheless replace year?


i dirt off vbscript shawl model asp query sql server 2000 database.



here's scenario:




  • i have twin datetime fields called fielda fieldb.

  • fieldb never have year value that's incomparable year fielda

  • it is illusory twin fields have same year.



what i wish annals where fielda >= fieldb, independent year. only feign any domain only month & day.



how i this? trust t-sql date/time functions disproportionate during best.



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?