python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - truncate

Postgres truncates function names even though they are less than 63 characters

I have this issue with the latest pg admin where postgres is automatically truncating function names less than 63 characters. I don't know if it's related to language or something else, but here's a f...
test-img

Michael Efraimidis

postgresql

function

truncate

Votes: 0

Answers: 1

Latest Answer

"4.1.1. Identifiers and Key Words": The system uses no more than NAMEDATALEN-1 bytes of an identifier; longer names can be written in commands, but they will be truncated. By default, NAMED...
test-img

sticky bit

Cassandra materialized view on collection truncate

If I truncate the entire source table in Cassandra. How will the MV(materialized views)'s have that reflection. Does this process may create parity between source partition and MV's if the data is con...
test-img

user3170732

cassandra

truncate

materialized-views

Votes: 0

Answers: 0

Truncate timestamp to custom unit of time in SQL Snowflake

Function DATE_TRUNC in Snowflake (Docs here) allows you to truncate a given timestamp to a given default unit of time, being available: 'YEAR', 'MONTH', 'DAY', 'HOUR', 'MINUTE' and 'SECOND' As an ex...
test-img

alvaropr

timestamp

snowflake-cloud-data-platform

truncate

Votes: 0

Answers: 3

Latest Answer

Change to epoch seconds, division, floor, multiply thus for 30 seconds steps: SELECT TO_TIMESTAMP_NTZ('2015-05-08T23:39:35.123') as date ,DATE_PART(epoch_second, date) as epoch_sec ,floor...
test-img

Simeon Pilgrim

SQL Server sys.tables not capturing correct modify_date

Context: I have an ETL process setup to populate tables in a datawarehouse using a Python script. The script executes a truncate statement via sqlalchemy to empty each of the tables then uses the pand...
test-img

emalcolmb

sql-server

pandas

sqlalchemy

truncate

pandas-to-sql

Votes: 0

Answers: 1

Latest Answer

modify_date doesn't capture TRUNCATE (or any changes to the data). From the documentation on sys.objects (which is where sys.tables gets its columns): Date the object was last modified by using an AL...
test-img

Aaron Bertrand

Posts

Questions

Blogs

Jobs