[MS-SQL] DB에 있는 날짜데이터 변환 쿼리 (파이썬으로 호출 시)

SELECT DISTINCT BRAND FROM NVR_SHP_BRNDAY WHERE EVENT_DATE = CONVERT(CHAR(10), GETDATE(), 23)

SELECT  BRAND FROM NVR_SHP_CAL WHERE CONVERT(VARCHAR(10), REPLACE(EVENT_DATE, '.', '-') , 23)  = CONVERT(CHAR(10), GETDATE(), 23)

 

============================================================================

 

#Python과 MSSQL 연결

import pymssql

 

server = 'crwsever.japaneast.cloudapp.azure.com'

database = 'CRWDB'

username = 'crwuser01'

password = 'qwer12#$'

 

cnxn = pymssql.connect(server, username, password, database)

cursor = cnxn.cursor()

 

cursor.execute('SELECT DISTINCT BRAND FROM NVR_SHP_BRNDAY WHERE EVENT_DATE = CONVERT(CHAR(10), GETDATE(), 23);')

 

row = cursor.fetchone()

while row:

    print(row[0])

    row = cursor.fetchone()