Timestamp with milliseconds

milij · #1 23rd October 2020, 01:48 AM

hello,
please how do i select full timestamp? i mean even with milliseconds.

I still getting:
22.10.2020 15:11:33
instead of
22.10.2020 15:11:33.153

Eivind · #2 23rd October 2020, 01:46 PM

Quote:

Originally Posted by milij

hello,
please how do i select full timestamp? i mean even with milliseconds.

I still getting:
22.10.2020 15:11:33
instead of
22.10.2020 15:11:33.153

Use ToString(), or client side formatting.

milij · #3 23rd October 2020, 07:01 PM

oh, thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TIMESTAMP vs CAST(xx AS TIMESTAMP)	SteveM	nexusdb.public.support.sql	6	25th August 2018 03:51 AM
Idea: Have Embeded engine close files after x milliseconds.	billegge	nexusdb.public.discussions	0	11th June 2015 08:57 AM
Joining a table based on times that differ by milliseconds	gregburke	nexusdb.public.support.sql	1	9th May 2012 02:24 PM
DateTime + Milliseconds	Thijs4321	nexusdb.public.support.sql	1	11th February 2010 01:11 AM
Help with SQL timestamp	Scott Martin	nexusdb.public.support.sql	1	17th November 2006 03:08 AM