title: How do you UNLOAD data to S3 from Redshift in AWS Pipeline and include a date in the filename
body: <p>I have a database table on Redshift I want to UNLOAD to S3 each month [through AWS Pipeline]. I have this code that works, but ideally I'd like to add in the current month to the filename too</p>
  <pre><code>UNLOAD ('
  select  *
  from reportingsandbox.tmp_test
  
  
  ')
  TO 's3://reporting-team-bucket/importfiles/test_123.csv' CREDENTIALS             'aws_access_key_id=123456678;aws_secret_access_key=abcdefg' 
  ALLOWOVERWRITE
  delimiter ',' 
  PARALLEL OFF ;
  </code></pre>
  <p>I've tried this to add in the month, but it has not worked, do you know if it is possible?</p>
  <p>Thanks</p>
  <pre><code>'s3://reporting-team-bucket/importfiles/test_123{month(myDateTime)}.csv' 
  </code></pre>