Hi,
What is the equivalent for below Oracle's ALTER SESSION query :
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:mi:ss'
Thanks,
SamActually I don't think there is one. SET DATEFORMAT has no affect on the way datetime or smalldatetime values are displayed.
Sunday, March 11, 2012
ALTER SESSION query ?
Labels:
alter,
below,
database,
equivalent,
hh24miss,
microsoft,
mysql,
nls_date_format,
oracle,
query,
server,
session,
sql,
yyyy-mm-dd
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment