YouScan: Convert datetime from GST to IST

YouScan, a popular social media monitoring tool, by default, returns data in GST (Gulf Standard Time) format. However, there might be instances where you need to convert this data to IST (Indian Standard Time) format. This conversion can be achieved using an expression.

Use the following expression to convert the GST data to IST: [column_name]+Interval '330 minutes'

This expression adds 330 minutes (or 5 hours and 30 minutes, which is the time difference between GST and IST) to the GST time, effectively converting it to IST.

Example

If the GST time is 12:00 PM, applying the expression will give you the IST time as 5:30 PM.

Additional References

• Youscan Connector in Bold BI