Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts
Wednesday, November 28, 2018
Postgres SQL
To get the 12HH with AM/PM
select to_char(create_date at time zone 'utc', 'HH12:MI:SS AM') as "createdate", proc_type, state, * from vb_proc_queue where proc_type='Email1SubsqSignUpNotify' order by create_date desc
04:18:19 PM
Subscribe to:
Posts (Atom)
-
In my current company, I'm using Visual Paradigm for my documentation task. If you go there site, you can either download community and ...
-
I spend many days to figure it out my problem in Vagrant. After I posted my question in stackoverflow, nobody is helping me instead they dow...
-
I used KeePass long time ago and until now I'm still using it. It's a great tool to save your password encrypted. At my home, I sa...