Populating A Form:Time Field

[nofue]

In a form, I have a field 'time' as type.
Trying to populate it with the current_time just doesn't work.
I tried in several "flavors", as format('HH24:MI', current_time); current_time; now; get_currenttime(), but nothing did work.
Using format('HH24:MI', current_time) didn't deliver anything, so the placeholder text is shown, using "current_time" populates the field with 00:00, which isn't of much help either.

So how can a field 'time' as type be populated (like the date field using current_date)?

[lovasoa]

The format to use is HH:MM. How to generate it depends on your database.

db	naive sql	timezone-aware sql	notes
PostgreSQL	to_char( current_time, 'HH24:MI' )	to_char( current_timestamp AT TIME ZONE 'Europe/Paris', 'HH24:MI' )	current_time uses the session time zone. AT TIME ZONE converts to the target zone.
MySQL	DATE_FORMAT( CURRENT_TIME(), '%H:%i' )	DATE_FORMAT( CONVERT_TZ( NOW(), @@session.time_zone, 'Europe/Paris' ), '%H:%i' )	CONVERT_TZ requires time zone tables to be loaded.
SQLite	strftime( '%H:%M', 'now' )	strftime( '%H:%M', 'now', '+2 hours' )	No built-in named time zone support. Use offsets, not IANA names.
SQL Server (MSSQL)	FORMAT( GETDATE(), 'HH:mm' )	FORMAT( SYSDATETIMEOFFSET() AT TIME ZONE 'Romance Standard Time', 'HH:mm' )	Uses Windows time zone names, not IANA names. Paris maps to Romance Standard Time.

[lovasoa]

If you want to set it to the current time in the user's own timezone wherever they are, you'll need custom javascript.

[nofue]

to_char(
current_timestamp
AT TIME ZONE 'Europe/Paris',
'HH24:MI'
)
did the trick. Thanks.