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.
Showing posts with label session. Show all posts
Showing posts with label session. Show all posts
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:
Posts (Atom)