Go: Format timestamp to default postgres format

Question

How do I make the timestamp format:

2015-01-25T22:22:46+08:00

look like this

2015-01-25T22:22:46.923331Z

To get the first format, I used

time.Now().Format(time.RFC3339)

The second format is the default postgres format that I'm trying to duplicate. Thanks!

Toni Cárdenas · Accepted Answer · 2015-01-25 14:48:27Z

3

Use "2006-01-02T15:04:05.000000Z" as the format instead. It's just RFC3339 with decimals added.

answered Jan 25, 2015 at 14:33

Toni Cárdenas

6,9381 gold badge21 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

still didn't get this part: 923331Z

It didn't? It works for me: play.golang.org/p/CsEZfbnz_b gives 2015-01-25T15:47:58.411372Z