title: How to set date format for the result of a SELECT statement in SQL Server
body: <p>I know how to use CONVERT function in SELECT statement to change the format of the Date column:</p>
  
  <pre><code>   SELECT 
         StationID
         , CONVERT(varchar, [Date], 101) as Date
         , Value 
     FROM my_table 
  </code></pre>
  
  <p>But I was wondering if I can set the date format in general before running the SELECT statement, when I don't know the name of the date column in the following SELECT statement: </p>
  
  <pre><code>   SELECT * from FROM my_table 
  </code></pre>
  
  <p>Is any SET statement or other T-SQL that I can run before my SELECT statement so that I can change the Date format temporarily?</p>
  
  <p>Thank you</p>