Posts by Elaine Xavier • 41 points
5 posts
-
0
votes0
answers81
viewsQ: Format data(date sql type) with javascript without changing the type
Take a date field of type date yyyy-MM-dd (sql) use a javascript function directly in the XML file to show this date in dd-MM-yyyy format without changing the type, remaining Date. It is possible?…
-
1
votes1
answer65
viewsQ: Date field display
I have a date in the format americado yyyy-mm-dd and I would like to put it in the Brazilian format dd-mm-yyyy but I don’t want to do it as conversion to_char. I need you to continue with the date…
-
0
votes2
answers153
viewsQ: SQL - Insert that receives calculated values from other columns of other tables
I want to do an Insert where the sales value column (from the sales table) is filled automatically which will be the unit value(contained in the product table) * quantity (this in the sales table).…
postgresqlasked Elaine Xavier 41 -
2
votes3
answers124
viewsQ: Return only the time in Select
How do I return only the time in Select? I declared the time as TIMESTAMP, in this case returned the date and time, but I want to return only the time. So I declared only DATE and now the time does…
oracle11gasked Elaine Xavier 41 -
1
votes1
answer150
viewsQ: To display the day of the week of any date in the last 1,000 years
I used this command select to_char(to_date('18-apr-1972','dd-mon-yyyy'),'day') day from DUAL; but gave error in execution: ORA-01841: ano (completo) deve estar entre -4713 e +9999 e não pode ser…