0

I need to convert datetime to Quarter. I have date time as the date type - 2009-01-01 00:00:00.000

how do I convert this 01 to Quarter "1" for example?

user13739771
  • 21
  • 4
  • I gave you a follow on to your last question: https://stackoverflow.com/questions/63105494/converting-month-numberdate-time-or-4-byte-integer-to-month-namestring-ssis/63119679#63119679 – KeithL Jul 29 '20 at 13:57

1 Answers1

1

Per the documentation you can use the datepart function with the q or qq argument:

datepart("q", YourDateColumn)
iamdave
  • 12,023
  • 3
  • 24
  • 53