Tyson Ninyette Posted September 3, 2021 Share Posted September 3, 2021 Hi, Just trying to turn a timestamp to 12hr binned expression. Would like to know how to group them by hour 1/2/3/4/5/6/7/8/9/10/11/12 Time stamp example: 23/08/2021 6:00:00 AM Time stamp example: 23/08/2021 8:59:36 AM Link to comment Share on other sites More sharing options...
Fabian Duerr Posted September 8, 2021 Share Posted September 8, 2021 Please use: DatePart('hour', [your.DTTM.column])Example: DatePart('hour', ParseDateTime("2013-09-17 10:30", "yyyy-MM-dd h:mm")) -> 10 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now