senior walk

SQL to find current term Start and End Dates

  • Publication date 2011-08-25
  • Categories: Notes
  • Categories:

select course_id||’,’||batch_uid||’,’||course_name||’,’||start_date||’,’||end_date from course_main where batch_uid LIKE ‘1119%’; returns: 1119-THEUA-WLLC-4033-SEC001-9323,1119-THEUA-WLLC-4033-SEC001-9323,WLLC 4033 – Language Teaching and Video Applications (1119-THEUA- WLLC-4033-SEC001-9323),2011-08-21 00:00:00,2012-01-13 00:00:00 1119-THEUA-WLLC-4033-SEC001-9324,1119-THEUA-WLLC-4033-SEC001-9324,WLLC 4033 – Language Teaching and Video Applications (1119-THEUA- WLLC-4033-SEC001-9324),2011-08-21 00:00:00,2012-01-13 00:00:00]]>