How do I pass a variable into date_part function in postgresql?

Question

I'm passing a variable from my function into the date_part function but I keep getting a syntax error. Tried these 2 examples below and still got a syntax error.

Example 1:

_month = date_part('month', timestamp NEW."sdate");

Example 2:

_month = date_part('month', timestamp format('%s',NEW."sdate"));

Can anyone tell me how do I pass my variable into this function?

what is the error

lat long
– lat long

2018-01-26 05:15:23 +00:00
Commented Jan 26, 2018 at 5:15 — lat long
– lat long, Commented Jan 26, 2018 at 5:15
syntax error at or near "format"

Joshua Rajandiran
– Joshua Rajandiran

2018-01-26 05:16:34 +00:00
Commented Jan 26, 2018 at 5:16 — Joshua Rajandiran
– Joshua Rajandiran, Commented Jan 26, 2018 at 5:16

Kaushik Nayak · Accepted Answer · 2018-01-26 05:27:24Z

2

I think there is no need to use timestamp literal or format the string if you need to pass it to date_part function. If sdate is of type DATE , you may use it directly.

date_part('month',NEW."sdate");

If sdate is a proper date string such as '2018-01-26 13:15:20', then your first example should work fine - date_part('month', timestamp NEW."sdate");

answered Jan 26, 2018 at 5:27

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

How do I pass a variable into date_part function in postgresql?

Example 1:

Example 2:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Example 1:

Example 2:

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related