I have written a query in bigquery like below:

 SELECT date_trunc(dd.created_date, week) AS week_signup,
  COUNT(DISTINCT dd.user_id) AS total_signup,
  COUNT(dd.resume_upload_date) AS resume_uploaded
FROM
  devdb_mirror.developer_detail dd
  LEFT JOIN devdb_mirror.user_list_v4 du ON dd.id = du.id
WHERE
  regexp_extract(du.email, r '@(. )') != 'gmail.com'
GROUP BY
  date_trunc(dd.created_date, week);

Output:

i want the week_signup column data format like this(just month and day):

How can i write this in bigquery to get this??

CodePudding user response：

Use format_date for the same.

E.g. FORMAT_DATE("%a %d", date_trunc(dd.created_date, week))