What is an example of translating a date into julian format?
- 1 Answers
- 1257 Views
- I also Faced
- E-Mail Answers
Answer Posted / Pankaj Balodi
To convert a date into Julian format using SQL, you can use the function JULIAN() which returns the number of days elapsed since November 24th, 4713 B.C., considered to be day 0 in the Julian calendar. Example: SELECT JULIAN('2022-01-01')
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the best sql course?
what is collation? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
how to use regular expression in pattern match conditions? : Sql dba
Can we use distinct and group by together?
What is your daily office routine?
Is inner join faster than left join?
Is primary key always clustered index?
Does group by remove duplicates?
How do I remove duplicates in two columns?
what are aggregate and scalar functions? : Sql dba
Is primary key clustered index?
how many tables will create when we create table, what are they? : Sql dba
what are the advantages of sql ? : Sql dba
what is schema? : Sql dba
