Manipulating Dates, Datetimes, Unix Timestamps, and other date formatting tricks in Redshift


1 comment

  • Avatar
    Michelle Mangion

    Hi Charlotte,

    I don't know if there is a way I can insert a field into a fact table whereby I grab the current date just once for every new record created. The timestamp would not change after that. The use of this field is to catch the date when the new field was created.
    Is this possible please?

    Comment actions Permalink

Please sign in to leave a comment.