How can I format the date time field as per the desired output?

Getting Started, GridDB Discussion
1

I’m working with GridDB for a sensor sales department project, I’ve a orders datamodel, this model contains order details of different order purchased each day like vision or control sensor with their order_id, order_name, sensor_id, customer_id, product_name, sales_person, order_date, price.

I have a customer datamodel contain - customer_id, order_id(foreign_key), customer_name, total_order_purchased, product_name, total_sales I want to display all the customers who have purchased any sort of sensors after May, 2019 including order_id corresponding to customers details. Since i have a order_date field as datetime timestamp field so i want my output to look like

|Customer_name|Order_date|
|Mr.John|May, 2019|
|Mr.Smith|May, 2019|

So as you can notice I want my date to be formatted like above how to do this in GridDB?

I was trying to search this on google but couldn’t get a solution yet.

1 Like
2

Hey,

how’s you?

I think you should try this :point_right: How can I format the date time field as per the desired output?

Hope this will help you. Actually, I also faced the same problem then I followed this. So I suggested you to follow this.

Thanks.