• Ivy Seo

Combine Date and Time into Timestamp


Combine date + time column => timestamp_ column :

date = column : 'yyyy-mm-dd'

time = column : 'hh-mm-ss'

timestamp_ = column name which type is Timestamp.

Its value will be Date + Time: 'yyyy-mm-dd hh-mm-ss'


Postgresql Query from C# :

cmd.CommandText = 
"UPDATE Table_Name SET timestamp_ = (Table_Name.date + Table_Name.time)::timestamp";


Another example (to understand how this works) :


** to use Timestamp: need Timescaledb

> CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;



Recent Posts

See All

Generate unique filename: UUID, Path

A: using UUID let my_uuid = Uuid::new_v4(); let file_created = File::create(my_uuid.to_string()).expect("create file failed");     println!("uuid: {}", my_uuid); //  buffer write let mut file_ge

JSON - write .txt file in Rust

pub fn serialize_writeFile(data : &full_data ) -> Result<bool, modbus::Error> { // 1) takes data  // this function takes the m7_data object and serializes the contents and saves the results to a text

Serialize/Deserialize JSON in Rust

This README has some good examples. To deserialize in Rust: use serde::{Deserialize, Serialize}; use serde_json::Result; #[derive(Serialize, Deserialize)] struct Person {     name: String,     age: u