Forum Discussion

softech's avatar
softech
Guide
8 months ago

query with date field

trying to find out posts between two dates in "message"   i have something like  https://mycommunity/api/2.0/search?q=SELECT%20post_time,%20post_time_friendly%20FROM%20messages%20WHERE%20ipost_tim...
  • HariniVuppala's avatar
    HariniVuppala
    8 months ago

    softech To get the accurate results, you can use the following query.

    select post_time, post_time_friendly from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00

HariniVuppala's avatar
HariniVuppala
Expert

softech To get the accurate results, you can use the following query.

select post_time, post_time_friendly from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00

softech's avatar
softech
Guide
8 months ago

perfect and works!!

 

my problem earlier was i used quotes around the date 😞

 

thanks