BiteSizedChunks.comLearn one small thing at a time.

Courses Suggested Paths Pricing

Course contentsShowHide

Databases & SQL

295smallint, integer, and bigint ranges
296numeric precision and scale
297real and double precision
298Floating-point NaN and infinity
299money type and locale dependence
300abs absolute values
301sign numeric signs
302ceil and ceiling
303floor downward rounding
304round numeric scale
305trunc fractional removal
306div integer quotient
307mod numeric remainder
308power exponentiation
309sqrt square roots
310cbrt cube roots
311exp exponential values
312ln natural logarithms
313log base-ten and arbitrary-base logarithms
314log10 explicit decimal logarithms
315factorial numeric products
316gcd greatest common divisor
317lcm least common multiple
318pi mathematical constant
319degrees and radians conversion
320sin, cos, and tan
321asin, acos, and atan
322atan2 quadrant-aware angles
323sind, cosd, and tand
324asind, acosd, atand, and atan2d
325sinh, cosh, and tanh
326asinh, acosh, and atanh
327width_bucket histogram bins
328random pseudorandom values
329setseed reproducible random sequences
330Calculating tax with exact decimal arithmetic
331date calendar values
332time without time zone
333time with time zone limitations
334timestamp without time zone
335timestamp with time zone
336interval fields and storage
337ISO 8601 temporal literals
338DateStyle and ambiguous date input
339IntervalStyle output
340CURRENT_DATE
341CURRENT_TIME and LOCALTIME
342CURRENT_TIMESTAMP and LOCALTIMESTAMP
343now transaction timestamps
344transaction_timestamp transaction start
345statement_timestamp statement start
346clock_timestamp wall-clock time
347timeofday textual clock readings
348TimeZone session settings
349AT TIME ZONE conversion
350AT LOCAL time-zone conversion
351Daylight saving gaps and folds
352Timestamp infinity values
353Subtracting dates versus timestamps
354Adding intervals to timestamps
355Month arithmetic and end-of-month behavior
356extract temporal fields
357date_part field extraction
358date_trunc temporal buckets
359date_bin arbitrary interval buckets
360age symbolic intervals
361make_date date construction
362make_time time construction
363make_timestamp timestamp construction
364make_timestamptz zone-aware construction
365make_interval interval construction
366to_timestamp epoch conversion
367to_timestamp format parsing
368to_date formatted date parsing
369to_char numeric formatting
370to_char timestamp formatting
371to_number formatted numeric parsing
372isfinite temporal bounds
373justify_days interval normalization
374justify_hours interval normalization
375justify_interval mixed normalization
376OVERLAPS temporal predicates
377generate_series timestamp sequences
378Generating a complete sales calendar
379Calculating subscription renewal dates
380Converting global flight departures to local time
381Measuring support response durations
382Reporting daily revenue across daylight saving changes

Databases & SQL

295smallint, integer, and bigint ranges
296numeric precision and scale
297real and double precision
298Floating-point NaN and infinity
299money type and locale dependence
300abs absolute values
301sign numeric signs
302ceil and ceiling
303floor downward rounding
304round numeric scale
305trunc fractional removal
306div integer quotient
307mod numeric remainder
308power exponentiation
309sqrt square roots
310cbrt cube roots
311exp exponential values
312ln natural logarithms
313log base-ten and arbitrary-base logarithms
314log10 explicit decimal logarithms
315factorial numeric products
316gcd greatest common divisor
317lcm least common multiple
318pi mathematical constant
319degrees and radians conversion
320sin, cos, and tan
321asin, acos, and atan
322atan2 quadrant-aware angles
323sind, cosd, and tand
324asind, acosd, atand, and atan2d
325sinh, cosh, and tanh
326asinh, acosh, and atanh
327width_bucket histogram bins
328random pseudorandom values
329setseed reproducible random sequences
330Calculating tax with exact decimal arithmetic
331date calendar values
332time without time zone
333time with time zone limitations
334timestamp without time zone
335timestamp with time zone
336interval fields and storage
337ISO 8601 temporal literals
338DateStyle and ambiguous date input
339IntervalStyle output
340CURRENT_DATE
341CURRENT_TIME and LOCALTIME
342CURRENT_TIMESTAMP and LOCALTIMESTAMP
343now transaction timestamps
344transaction_timestamp transaction start
345statement_timestamp statement start
346clock_timestamp wall-clock time
347timeofday textual clock readings
348TimeZone session settings
349AT TIME ZONE conversion
350AT LOCAL time-zone conversion
351Daylight saving gaps and folds
352Timestamp infinity values
353Subtracting dates versus timestamps
354Adding intervals to timestamps
355Month arithmetic and end-of-month behavior
356extract temporal fields
357date_part field extraction
358date_trunc temporal buckets
359date_bin arbitrary interval buckets
360age symbolic intervals
361make_date date construction
362make_time time construction
363make_timestamp timestamp construction
364make_timestamptz zone-aware construction
365make_interval interval construction
366to_timestamp epoch conversion
367to_timestamp format parsing
368to_date formatted date parsing
369to_char numeric formatting
370to_char timestamp formatting
371to_number formatted numeric parsing
372isfinite temporal bounds
373justify_days interval normalization
374justify_hours interval normalization
375justify_interval mixed normalization
376OVERLAPS temporal predicates
377generate_series timestamp sequences
378Generating a complete sales calendar
379Calculating subscription renewal dates
380Converting global flight departures to local time
381Measuring support response durations
382Reporting daily revenue across daylight saving changes

← Databases & SQL

Search the Databases & SQL glossary

Lesson 300 of 2,478·6. Numeric and Temporal ComputationFree lesson

abs absolute values

Writing your lesson…

← Previous Next lesson →

© 2026 BiteSizedChunks.com. Learn one small thing at a time.

Glossary Contact Terms of Service Privacy Policy