How do I display today's date twice in PostgreSQL











up vote
0
down vote

favorite












SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy');


The above query displays only once.



I want to display the above date twice or more.






sql postgresql select







share|improve this question




















  • 1




    SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy'), TO_CHAR(now() :: DATE, 'dd/mm/yyyy') ?
    – Cid
    yesterday















up vote
0
down vote

favorite












SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy');


The above query displays only once.



I want to display the above date twice or more.






sql postgresql select







share|improve this question




















  • 1




    SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy'), TO_CHAR(now() :: DATE, 'dd/mm/yyyy') ?
    – Cid
    yesterday













up vote
0
down vote

favorite









up vote
0
down vote

favorite











SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy');


The above query displays only once.



I want to display the above date twice or more.






sql postgresql select







share|improve this question















SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy');


The above query displays only once.



I want to display the above date twice or more.






sql postgresql select




sql postgresql select






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited yesterday









Mureinik

175k21124191




175k21124191










asked yesterday









abdul

41




41








  • 1




    SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy'), TO_CHAR(now() :: DATE, 'dd/mm/yyyy') ?
    – Cid
    yesterday














  • 1




    SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy'), TO_CHAR(now() :: DATE, 'dd/mm/yyyy') ?
    – Cid
    yesterday








1




1




SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy'), TO_CHAR(now() :: DATE, 'dd/mm/yyyy') ?
– Cid
yesterday




SELECT TO_CHAR(now() :: DATE, 'dd/mm/yyyy'), TO_CHAR(now() :: DATE, 'dd/mm/yyyy') ?
– Cid
yesterday












1 Answer
1






active

oldest

votes

















up vote
2
down vote













If you want to display the same date twice side to side, just query it twice:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy'), TO_CHAR(now()::DATE, 'dd/mm/yyyy');


If you want to display multiple rows, you can use a set-generating function, such as generate_series:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy')

FROM   GENERATE_SERIES(1, 2)





share|improve this answer





















  • Thanks a lot,perfect
    – abdul
    yesterday











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53370730%2fhow-do-i-display-todays-date-twice-in-postgresql%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes








up vote
2
down vote













If you want to display the same date twice side to side, just query it twice:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy'), TO_CHAR(now()::DATE, 'dd/mm/yyyy');


If you want to display multiple rows, you can use a set-generating function, such as generate_series:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy')

FROM   GENERATE_SERIES(1, 2)





share|improve this answer





















  • Thanks a lot,perfect
    – abdul
    yesterday















up vote
2
down vote













If you want to display the same date twice side to side, just query it twice:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy'), TO_CHAR(now()::DATE, 'dd/mm/yyyy');


If you want to display multiple rows, you can use a set-generating function, such as generate_series:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy')

FROM   GENERATE_SERIES(1, 2)





share|improve this answer





















  • Thanks a lot,perfect
    – abdul
    yesterday













up vote
2
down vote










up vote
2
down vote









If you want to display the same date twice side to side, just query it twice:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy'), TO_CHAR(now()::DATE, 'dd/mm/yyyy');


If you want to display multiple rows, you can use a set-generating function, such as generate_series:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy')

FROM   GENERATE_SERIES(1, 2)





share|improve this answer












If you want to display the same date twice side to side, just query it twice:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy'), TO_CHAR(now()::DATE, 'dd/mm/yyyy');


If you want to display multiple rows, you can use a set-generating function, such as generate_series:



SELECT TO_CHAR(now()::DATE, 'dd/mm/yyyy')

FROM   GENERATE_SERIES(1, 2)






share|improve this answer












share|improve this answer



share|improve this answer










answered yesterday









Mureinik

175k21124191




175k21124191












  • Thanks a lot,perfect
    – abdul
    yesterday


















  • Thanks a lot,perfect
    – abdul
    yesterday
















Thanks a lot,perfect
– abdul
yesterday




Thanks a lot,perfect
– abdul
yesterday


















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53370730%2fhow-do-i-display-todays-date-twice-in-postgresql%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Feedback on college project

Image
5 0 $begingroup$ I would appreciate some feedback regarding best practices on the following code for a college project. What should go in the controller and what in the views? How to attach and remove the views to the single main frame? Change the Controller after successful login? Studentenverwaltung.java package com.studentenverwaltung; import com.studentenverwaltung.controller.LoginController; import com.studentenverwaltung.model.User; import com.studentenverwaltung.view.LoginView; import javax.swing.*; import java.awt.*; class Studentenverwaltung implements Runnable { public static void main(String args) { EventQueue.invokeLater(new Studentenverwaltung()); } @Override public void run() { User user = new User(); LoginView loginView = new LoginView(u...
Read more

Futebolista

Image
Ronaldo primeiro jogador a ser eleito por três vezes o melhor jogador do mundo pela FIFA. Ronaldinho Gaúcho atuando pelo Barcelona onde foi duas vezes eleito o melhor jogador do mundo pela FIFA. Kaká atuando pelo Milan onde foi eleito em 2007 o melhor jogador do mundo pela FIFA. Lothar Matthäus primeiro jogador a ser eleito o melhor jogador do mundo pela FIFA em 1991 pela Inter de Milão. Neymar durante partida contra a Escócia, em 27 de março de 2011. Crianças praticando futebol. Robinho, futebolista brasileiro, em 15 de novembro de 2006. Atletas do Chelsea, da Inglaterra. A venda de camisas com nome e número dos jogadores é uma grande fonte de arrecadação. Jürgen Klinsmann atuou como jogador e foi treinador da Alemanha. Estádio de futebol, principal local onde laboram os jogadores. O jogador de futebol , ou Futebolista , é um atleta profissional de futebol, e cuja prática do desporto coletivo é fundamental. Estes trabalhadores sã...
Read more

Albești (Vaslui)

Image
Coordenadas: 46 42 ºN 27 33 ° L Albeşti      Comuna    Região histórica Moldávia Distrito Vaslui Área  - Total 59,10 km² População (2007)  - Total 3 303     • Densidade 55,9 hab./km² Sítio www.albesti.ro/ Albeşti é uma comuna romena localizada no distrito de Vaslui, na região de Moldávia. A comuna possui uma área de 59.10 km² e sua população era de 3303 habitantes segundo o censo de 2007. [ 1 ] Referências ↑ «População em 1 de janeiro de 2009». INSSE   Distrito de Vaslui da Romênia Municípios Vaslui | Bârlad | Huşi Cidades Murgeni | Negreşti Comunas Albeşti | Alexandru Vlahuţă | Arsura | Banca | Băcani | Băceşti | Bălteni | Berezeni | Blăgeşti | Bogdana | Bogdăneşti | Bogdăniţa | Boţeşti | Buneşti-Avereşti | Ciocani | Codăeşti | Coroieşti | Costeşti | Cozmeşti | Creţeşti | Dăneşti | Deleni | Deleşti | Dimitrie Cantemir | Dodeşti | Dragomireşti...
Read more