Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I want to return all values from a table only if the value in a date column is in the future. 

I think the simplest way to do this is to get a value for what `now` is, like below. 

My question: is there a built-in way of doing `now` in PSQL?

```ts
const now = new Date().getTime();

export const listPosts = async (): Promise<PostgrestResponse<PostTable>> => {
  return supabase
    .from<PostTable>('posts')
    .select('*')
    .gt('expires_at', now)
};
```

```ts
export const listPosts = async (): Promise<PostgrestResponse<PostTable>> => {
  return supabase
    .from<PostTable>('posts')
    .select('*')
    .gt('expires_at', 'now()')
};
```

This is what happens when you try to code at 11pm after a long day 😅

<@!819391236523425863> You can even do `.gt('expires_at', 'yesterday')` or `.gt('expires_at', 'tomorrow')` 🙂 

Those are special values in PostgreSQL, that's why they work(also they don't need parens)