As someone that rarely uses SQL I'm trying to make use of it more and rely less on searches, where it's more efficient. However, today I tried to create a query and it seems "time of day" is not a field type you can filter on or include in the results columns? Can someone confirm or explain if there's a work around please?

What do you mean by time of day ?

Custom field on a record:

It's a date time field ?

If I go in to Analytics and look at the building a dataset it's not even listed.

Oh never noticed this type, wherever we had some time brackets in a field we were always sourcing a custom time list for those fields. Just tested it, not accessible in suiteql.

Thanks for confirming and... why the hell not? netsuite

apparently known limitation, possible work around is a field which sources from it and store it as a string, or just create a custom list for the time and use a select field or stick with search.

Thanks for the follow up.