msqr

SELECT 
	datum.ts_start AS r_datum_ts_start
	, datum.local_date AS r_datum_local_date
	, datum.node_id AS r_datum_node_id
	, datum.source_id AS r_datum_source_id
	, datum.jdata AS r_datum_jdata 
FROM ( 
	( 
		SELECT 
			date_trunc('year', datum.ts_start::timestamp) AT TIME ZONE r.time_zone AS ts_start 

msqr

// MIT License
// 
// Copyright (c) 2018 Matt Magoffin
// 
// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this software and associated documentation files (the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions:

msqr

This code is released under the MIT license.

Copyright (C) 2012 Matt Magoffin

Permission is hereby granted, free of charge, to any person obtaining a
copy of this software and associated documentation files (the
"Software"), to deal in the Software without restriction, including
without limitation the rights to use, copy, modify, merge, publish,
distribute, sublicense, and/or sell copies of the Software, and to
permit persons to whom the Software is furnished to do so, subject to