Format time

[Lasse Edsvik]

Hello

I'm trying to us the formatdatetime function to format US-time and it doesnt
give me the seconds

how to do that?

2002-02-02 06:00 AM gives 6:00 AM when I want 6:00:00 AM

/Lasse

 

[Aaron Bertrand - MVP]

Where are you getting the date/time from? A database, now(), some other
variable, ...?