HomeНаука и техникаRelated VideosMore From: Maruti AIR Tech

Custom date time format in Oracle SQL Developer?

8 ratings | 503 views
From Oracle SQL Developer's menu go to Tools -- Preferences. From the Preferences dialog, select Database -- NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS or for 24-Hour, DD-MON-YY HH24:MI:SS Or just for an active session use below instead. alter SESSION set NLS_DATE_FORMAT = 'required_date_format' i.e. alter SESSION set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS' into the Date Format field. Save and close the dialog.
Html code for embedding videos on your blog
Text Comments (5)
Kids Toys (7 months ago)
tnx
Kids Toys (7 months ago)
was easy
You Gamerz (7 months ago)
thanks...
Isha Makhija (7 months ago)
Thanks.... very helpful
Maruti AIR Tech (7 months ago)
Glad to know it helped. Please like and subs....

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.